To view a trigger for a table

SQL Server queries all trigger names for a table

Find out all SQL used for a table

SELECT * from sysobjects where xtype= ' TR '
SELECT * from sysobjects where xtype= ' TR ' and parent_obj=object_id (' Table name ')

View triggers for SQL exec sp_helptext ' Trg_tm_room_change_getmaxchangeid '
Xtype char (2) object type. Can be one of the following object types:
C = CHECK Constraint
D = defaults or DEFAULT constraints
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = Inline Table function
P = Stored Procedure
PK = PRIMARY KEY constraint (type is K)
RF = copy Filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User Table
UQ = UNIQUE constraint (type is K)
V = view
X = Extended Stored Procedure

To view a trigger for a table