Unable to find where triggers are stored in sql server 2008

Question

I want to delete and modify previously created triggers but i cant find them anywhere in database. Where they exist and how to edit or delele them

Answer 1

Under the Tables node in SSMS (SQL Server Management Studio), for each table there is a Triggers node.

You can manage your triggers from there.

Answer 2

Answer 3

You can also find the triggers by querying the management views in SQL Server Management Studio:

SELECT
    OBJECT_NAME(object_id) 'Table name', *
FROM 
    sys.triggers

That gives you a list of all triggers and what table they're defined on for your current database. You can then go on to either disable or drop them.