When you open a SQL Server database that has Triggers, it is not at all obvious how you might find them and enumerate their contents. The following SQL code will show you all the triggers in your database including which table they are associated with.

SELECT name AS 'Trigger Name', OBJECT_NAME(parent_obj) AS 'Table'
FROM sysobjects
WHERE xtype = 'TR'

The results will be in this format.

 

From here, you can enumerate their contents like this

sp_helptext TriggerName

You can also view all the triggers associated with a particular table with this code.

sp_helptrigger TableName