sql server show triggers

Solutions on MaxInterview for sql server show triggers by the best coders in the world

showing results for - "sql server show triggers"
Lia
03 Jan 2018
1SELECT  table_name = OBJECT_NAME(parent_object_id) ,
2        trigger_name = name ,
3        trigger_owner = USER_NAME(schema_id) ,
4        OBJECTPROPERTY(object_id, 'ExecIsUpdateTrigger') AS isupdate ,
5        OBJECTPROPERTY(object_id, 'ExecIsDeleteTrigger') AS isdelete ,
6        OBJECTPROPERTY(object_id, 'ExecIsInsertTrigger') AS isinsert ,
7        OBJECTPROPERTY(object_id, 'ExecIsAfterTrigger') AS isafter ,
8        OBJECTPROPERTY(object_id, 'ExecIsInsteadOfTrigger') AS isinsteadof ,
9        CASE OBJECTPROPERTY(object_id, 'ExecIsTriggerDisabled')
10          WHEN 1 THEN 'Disabled'
11          ELSE 'Enabled'
12        END AS status
13FROM    sys.objects
14WHERE   type = 'TR'
15ORDER BY OBJECT_NAME(parent_object_id)
16
similar questions
queries leading to this page
sql server show triggers