Sharing my experiences with SQL programming...
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
No comments:
Post a Comment