sys.trigger_events (Transact-SQL)
Contains a row per event for which a trigger fires.
Note
sys.trigger_events does not apply to event notifications.
Column name |
Data type |
Description |
|---|---|---|
<Columns inherited from sys.events> |
Not applicable |
Inherits the object_id, type, type_desc columns from sys.events. |
is_first |
bit |
Trigger is marked to be the first to fire for this event. |
is_last |
bit |
Trigger is marked to be the last to fire for this event. |
event_group_type |
int |
Event group on which the trigger is created, or null if not created on an event group. |
event_group_type_desc |
nvarchar(60) |
Description of the event group on which the trigger is created, or null if not created on an event group. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.