Trigger Content

Sql Server:

SELECT TR.NAME, COM.*

FROM SYS.TRIGGERS TR, SYSCOMMENTS COM

WHERE TR.OBJECT_ID = COM.ID

AND TR.NAME='triggerhere'

Oracle:

SELECT *

FROM all_constraints

WHERE table_name='NAME_OF_YOUR_TABLE'

AND constraint_type='C';