sys.trigger_events (Transact-SQL)sys.trigger_events (Transact-SQL)

适用于: 是SQL Server是Azure SQL 数据库否Azure SQL 数据仓库否并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

激发触发器的每个事件对应一行。Contains a row per event for which a trigger fires.

备注

sys.trigger_events不适用于事件通知。sys.trigger_events does not apply to event notifications.

列名Column name 数据类型Data type 描述Description
<从 sys.events 继承的列 ><Columns inherited from sys.events> 不适用Not applicable 继承object_id类型type_desc中的列sys.eventsInherits the object_id, type, type_desc columns from sys.events.
is_firstis_first bitbit 触发器标记为第一个为此事件激发的触发器。Trigger is marked to be the first to fire for this event.
is_lastis_last bitbit 触发器标记为最后一个为此事件激发的触发器。Trigger is marked to be the last to fire for this event.
event_group_typeevent_group_type intint 要对其创建触发器的事件组,如果未对事件组创建触发器,则为 Null。Event group on which the trigger is created, or null if not created on an event group.
event_group_type_descevent_group_type_desc nvarchar(60)nvarchar(60) 要对其创建触发器的事件组的说明,如果未对事件组创建触发器,则为 Null。Description of the event group on which the trigger is created, or null if not created on an event group.

权限Permissions

目录视图中仅显示用户拥有的安全对象的元数据,或用户对其拥有某些权限的安全对象的元数据。The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. 有关详细信息,请参阅 Metadata Visibility ConfigurationFor more information, see Metadata Visibility Configuration.

请参阅See Also

目录视图 (Transact-SQL) Catalog Views (Transact-SQL)
对象目录视图(Transact SQL)Object Catalog Views (Transact-SQL)