sp_helptrigger

SAP ASE version 16.0 includes the sp_helptrigger system procedure.

sp_helptrigger lists
  • All triggers created on the table specified by tablename
  • Which command (insert, update, or delete) fires the trigger
  • The trigger's order number

Syntax

sp_helptrigger tablename

Parameters

Permissions

Any user can execute sp_helptrigger.