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)
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir