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
- tablename – is the name of the table.
Permissions
Any user can execute sp_helptrigger.