sys.events (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Contains a row for each event for which a trigger or event notification fires. These events represent the event types that are specified when the trigger or event notification is created by using CREATE TRIGGER or CREATE EVENT NOTIFICATION.
| Column name | Data type | Description |
|---|---|---|
| object_id | int | ID of the trigger or event notification. This value, together with type, uniquely identifies the row. |
| type | int | Event that causes the trigger to fire. |
| type_desc | nvarchar(60) | Description of the event that causes the trigger to fire. |
| is_trigger_event | bit | 1 = Trigger event. 0 = Notification event. |
| event_group_type | int | Event group on which the trigger or event notification 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 or event notification is created, or null if not created on an event group. |
See Also
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)