Triggers in SQL of a table can be find by writing a SQL query and passing table name as its parameter for the query
We will just pass the table name for that and it will provide all the triggers made for that table.
Ex: select so.name, text
from sysobjects so, syscomments sc
where type = 'TR'
and so.id = sc.id
and text like '%Student%'
Second way to find triggers
Ex: SELECT
t.name AS TableName,
tr.name AS TriggerName
FROM sys.triggers tr
INNER JOIN sys.tables t ON t.object.id = tr.parent.id
WHERE
t.name in ('Student');
0 Comment(s)