Hafiz Suleman's Blog
Wednesday, January 5, 2011
How to Find all triggers in sql server along with table to which triggers are applied
Here is the way to find out all the triggers in sql server tables along with table to which it applies.
SELECT NAME AS TriggerName,OBJECT_NAME(parent_obj) AS TableName FROM sysobjects WHERE xtype='TR'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment