Skip to content

Latest commit

 

History

History
44 lines (37 loc) · 2.03 KB

sys-trigger-events-transact-sql.md

File metadata and controls

44 lines (37 loc) · 2.03 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
sys.trigger_events (Transact-SQL)
sys.trigger_events (Transact-SQL)
rwestMSFT
randolphwest
06/10/2016
sql
system-objects
reference
trigger_events_TSQL
trigger_events
sys.trigger_events
sys.trigger_events_TSQL
sys.trigger_events catalog view
TSQL
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.trigger_events (Transact-SQL)

[!INCLUDE 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

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

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