sp_helptrigger (Transact-SQL)
Returns the type or types of DML triggers defined on the specified table for the current database. sp_helptrigger cannot be used with DDL triggers. Query the system stored procedures catalog view instead.
The following table shows the information that is contained in the result set.
Column name |
Data type |
Description |
---|---|---|
trigger_name |
sysname |
Name of the trigger. |
trigger_owner |
sysname |
Name of the owner of the table on which the trigger is defined. |
isupdate |
int |
1=UPDATE trigger 0=Not an UPDATE trigger |
isdelete |
int |
1=DELETE trigger 0=Not a DELETE trigger |
isinsert |
int |
1=INSERT trigger 0=Not an INSERT trigger |
isafter |
int |
1=AFTER trigger 0=Not an AFTER trigger |
isinsteadof |
int |
1=INSTEAD OF trigger 0=Not an INSTEAD OF trigger |
trigger_schema |
sysname |
Name of the schema to which the trigger belongs. |
Requires Metadata Visibility Configuration permission on the table.