.png)
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.
