Tuesday, February 9, 2010

Finding the DDL Triggers in a database

Below is a method to list out DDL triggers which are created on your database

SELECT * FROM sys.triggers WHERE parent_class=0
 Please note that DDL triggers are not schema scoped and hence their information wont be available in system catalog view like sys.objects