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:-
