TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sys.trigger_events (Transact-SQL)

 

Updated: June 10, 2016

Contains a row per event for which a trigger fires.

System_CAPS_ICON_note.jpg Note


sys.trigger_events does not apply to event notifications.

Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
Column nameData typeDescription
<Columns inherited from sys.events>Not applicableInherits the object_id, type, type_desc columns from sys.events.
is_firstbitTrigger is marked to be the first to fire for this event.
is_lastbitTrigger is marked to be the last to fire for this event.
event_group_typeintEvent group on which the trigger is created, or null if not created on an event group.
event_group_type_descnvarchar(60)Description of the event group on which the trigger is created, or null if not created on an event group.

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.

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

Community Additions

ADD
Show:
© 2016 Microsoft