Blog Pages

Select triggers of a table

SELECT name,OBJECT_NAME(parent_object_id) 
FROM sys.objects 
WHERE type = 'TR' 
AND SCHEMA_NAME(schema_id) = 'dbo'
AND OBJECT_NAME(parent_object_id) = 'TABLENAME'

No comments:

Post a Comment