how to list out all triggers in a particular table OR database?

Question

how can I list out all triggers on a table?

Answer 1

The sys.triggers view contains information about the triggers, you can filter on parent_id if you want just one table. (Get the object id of the table or view with the OBJECT_ID() function)

OBJECT_DEFINITION() can be used to retrieve the text of the trigger, if required.

Answer 2

 select * from sys.triggers