Wednesday, December 20, 2017

How to find all triggers on a table in sql server ?

How to find all triggers on a table in sql server ?

=>

SELECT NAME, PARENT_ID, CREATE_DATE, MODIFY_DATE, S_INSTEAD_OF_TRIGGER  
FROM SYS.TRIGGERS  WHERE TYPE = 'TR';

     I am create one trigger  in sql server.trigger name like test trigger create then run above query to find your result.display all trigger in database and all table see output.

Output:-


No comments :

Post a Comment