List All Trigger In SQL Server? – The Code Hubs

List All Trigger In SQL Server?

Shaikh Hafeezjaha Nov 19, 2019 0 203

Forums › SQL › List All Trigger In SQL Server?

0 Vote Up Vote Down

Shaikh Hafeezjaha

Staff asked 5 years ago

How to find the total trigger in the particular database

Answers (1)

Add Answer

0 Vote Up Vote Down

Sagar Rana Marked As Accepted

Staff answered 5 years ago

Try this

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