| 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 |
|
||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb |
[!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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)