sp_helptrigger

sp_helptrigger lists all triggers created on the table specified by tablename; which command (insert, update, or delete) fires the trigger, and the trigger's order number.

Syntax

sp_helptrigger tablename

Parameters

Permissions

Any user can execute sp_helptrigger.