Skip to content

Latest commit

 

History

History
47 lines (39 loc) · 2.1 KB

File metadata and controls

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

sys.trigger_events (Transact-SQL)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

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)