Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Contains a row for each object that is a trigger, with a type of TR or TA. DML trigger names are schema-scoped and, therefore, are visible in sys.objects. DDL trigger names are scoped by the parent entity and are only visible in this view.
The parent_class and name columns uniquely identify the trigger in the database.
| Column name | Data type | Description |
|---|---|---|
name |
sysname |
Trigger name. DML trigger names are schema-scoped. DDL trigger names are scoped with respect to the parent entity. |
object_id |
int |
Object identification number. Is unique within a database. |
parent_class |
tinyint |
Class of the parent of the trigger. 0 = Database, for the DDL triggers. 1 = Object or column for the DML triggers. |
parent_class_desc |
nvarchar(60) |
Description of the parent class of the trigger. DATABASE OBJECT_OR_COLUMN |
parent_id |
int |
ID of the parent of the trigger, as follows: 0 = Triggers that are database-parented triggers. For DML triggers, this is the object_id of the table or view on which the DML trigger is defined. |
type |
char(2) |
Object type: TA = Assembly (CLR) trigger TR = SQL trigger |
type_desc |
nvarchar(60) |
Description of object type. CLR_TRIGGER SQL_TRIGGER |
create_date |
datetime |
Date the trigger was created. |
modify_date |
datetime |
Date the object was last modified by using an ALTER statement. |
is_ms_shipped |
bit |
Trigger created on behalf of the user by an internal SQL Server 2005 component. |
is_disabled |
bit |
Trigger is disabled. |
is_not_for_replication |
bit |
Trigger was created as NOT FOR REPLICATION. |
is_instead_of_trigger |
bit |
1 = INSTEAD OF triggers 0 = AFTER triggers. |
See Also
Reference
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)