List All Trigger In SQL Server?

Forums SQLList All Trigger In SQL Server?
Staff asked 4 years ago

How to find the total trigger in the particular database

Answers (1)

Add Answer
Nishant Kakadiya Marked As Accepted
Staff answered 4 years ago

Try this

SELECT name,
is_instead_of_trigger
FROM
sys.triggers
WHERE
type = ‘TR’;

Subscribe

Select Categories