sys.server_triggers (Transact-SQL)sys.server_triggers (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

包含所有 object_type 為 TR 或 TA 的伺服器層級 DDL 觸發程序組。Contains the set of all server-level DDL triggers with object_type of TR or TA. 如果是 CLR 觸發程序中,組件必須載入到主要資料庫。In the case of CLR triggers, the assembly must be loaded into the master database. 所有的伺服器層級 DDL 觸發程序名稱,都在一個全域範圍內。All server-level DDL trigger names exist in a single, global scope.

資料行名稱Column Name 資料類型Data Type 描述Description
namename sysnamesysname 觸發程序的名稱。Name of the trigger.
object_idobject_id intint 物件的識別碼。ID of the object.
parent_classparent_class tinyinttinyint 父系的類別。Class of parent. 它一律是:Is always:

100 = 伺服器100 = Server
parent_class_descparent_class_desc nvarchar(60)nvarchar(60) 父類別的描述。Description of class of parent. 它一律是:Is always:

SERVER。SERVER.
parent_idparent_id intint SERVER 上的觸發程序,一律為 0。Always 0 for triggers on the SERVER.
typetype char(2)char(2) 物件類型:Object type:

TA = 組件 (CLR) 觸發程序TA = Assembly (CLR) trigger

TR = SQL 觸發程序TR = SQL trigger
type_desctype_desc nvarchar(60)nvarchar(60) 物件類型類別的描述。Description of the class of the object type.

CLR_TRIGGERCLR_TRIGGER

SQL_TRIGGERSQL_TRIGGER
create_datecreate_date datetimedatetime 建立觸發程序的日期。Date the trigger was created.
modify_datemodify_date datetimedatetime 上次利用 ALTER 陳述式來修改觸發程序的日期。Date the trigger was last modified by using an ALTER statement.
is_ms_shippedis_ms_shipped bitbit 利用內部 SQL ServerSQL Server 元件來代表使用者所建立的觸發程序。Trigger created on behalf of the user by an internal SQL ServerSQL Server component.
is_disabledis_disabled bitbit 1 = 觸發程序已停用。1 = Trigger is disabled.

PermissionsPermissions

目錄檢視內中繼資料的可見性會限制在使用者所擁有的安全性實體,或已授與使用者某些權限的安全性實體。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)