Thursday, September 20, 2012

SQL Server: Find a Trigger By The Table Name

Given a table name, this is how to find the triggers that are on that table.

select name, object_name(parent_id) as parent from sys.triggers where object_name(parent_id) = 'MY_TABLE_NAME'

And next time you want to use a trigger in your webapp...don't.

No comments:

Post a Comment