List all triggers for a table or an entire database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Troy - 29 Mar 2006 22:41 GMT

How can I get a list of all the triggers associated with a particular
table in a database. And in addition, how can I get a list of all
triggers for the entire database (meaning all triggers associated with
all tables)? Thanks!!

Signature

Regards,

Troy

Reply to this Message

Troy - 29 Mar 2006 22:47 GMT

Troy,

>> How can I get a list of all the triggers associated with a particular
>> table in a database. And in addition, how can I get a list of all
>> triggers for the entire database (meaning all triggers associated with
>> all tables)? Thanks!!

answered my own question... here's the query in case someone else is
wondering:

SELECT S2.[name] TableName, S1.[name] TriggerName, CASE WHEN S1.deltrig

> 0 THEN 'Delete' WHEN S1.instrig > 0 THEN 'Insert' WHEN S1.updtrig > 0

THEN 'Update' END 'TriggerType' FROM sysobjects S1 JOIN sysobjects S2 ON
S1.parent_obj = S2.[id] WHERE S1.xtype='TR'

Signature

Regards,

Troy

Reply to this Message