Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Viewing DML Trigger Metadata

3> 4> SELECT OBJECT_NAME(parent_id) Table_or_ViewNM, 5> name TriggerNM, is_instead_of_trigger, is_disabled 6> FROM sys.triggers 7> WHERE parent_class_desc = 'OBJECT_OR_COLUMN' 8> ORDER BY OBJECT_NAME(parent_id), name 9> GO Table_or_ViewNM          TriggerNM                   is_instead_of_trigger is_disabled ------------------------------------------------------------------------------------------------------------------------ -------- --------------------------------------------------------------------------------------------------------------- ----------------- --------------------- ----------- 1>