sys.trigger_events (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
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 was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)