How do I list all Triggers in a database?

×

select Tables.Name as TableName,Triggers.name as TriggerName

from sysobjects Triggers,sysobjects Tables

where Triggers.xtype='TR'

AND Triggers.parent_obj = Tables.id

order by Tables.name