Write down a sql query to get all triggers in database?

1.	Write down a sql query to get all triggers in database?
Answer» Write down a SQL query to get all TRIGGERS in DATABASE? Below is the query to get all the triggers in database. Here we will USE sys.triggers to get all the triggers. SELECT name,is_instead_of_trigger FROM sys.triggers WHERE type = 'TR';

Discussion