sys.trigger_events (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)