Triggers can be seen in SSMS Object Explorer.

Trigger information access programmatically :

USE AdventureWorks2008;

EXEC sp_helptrigger 'Sales.SalesOrderHeader'

/*

trigger_name      trigger_owner     isupdate    isdelete    isinsert    isafter      isinsteadof trigger_schema

uSalesOrderHeader dbo   1     0     0     1     0     Sales

*/

-- SQL Server list all triggers in database

SELECT * FROM AdventureWorks2008.sys.triggers

/* Partial results

name                    object_id   parent_class      parent_class_desc

dEmployee               1483152329  1                 OBJECT_OR_COLUMN

iuPerson                1499152386  1                 OBJECT_OR_COLUMN

iPurchaseOrderDetail    1515152443  1                 OBJECT_OR_COLUMN

uPurchaseOrderDetail    1531152500  1                 OBJECT_OR_COLUMN

*/