 After | True if the trigger is an after trigger. |
| AnsiNullsOn | True if the trigger was created with ansi nulls on. |
| Assembly | The CLR assembly for the DDL trigger, for a CLR DDL trigger. |
| AssemblyClass | The CLR assembly class name for the DDL trigger, for a CLR DDL trigger. |
| AssemblyMethod | The CLR assembly method name for the DDL trigger, for a CLR trigger. |
| CLRObject | True if the DDL trigger is a Common Language Runtime (CLR) DDL trigger. |
| Database (Inherited from SchemaObject) | The database to which the object belongs. |
| Encrypted | True if the DDL trigger definition is encrypted. |
| EventTypes |
The event types for the DDL trigger.
|
| ExecuteAs |
The user whose security context is to be used for the execution of the DDL
trigger. This is a SQL Server 2005 feature.
|
| ExtendedProperties | The extended properties defined for the DDL trigger. |
| FullyQualifiedName | Overridden. The fully-qualified name of the DDL trigger. |
| InsteadOf | True if the trigger is an instead of trigger. |
| IsDisabled | True if the trigger is disabled. |
| Name (Inherited from SchemaObject) |
The name of the object.
|
| ObjectType | Overridden. Returns ObjectType.DdlTrigger |
| Owner (Inherited from SchemaObject) |
The owner or the schema of the object.
|
| Permissions (Inherited from SchemaObject) | The permissions on the object. |
| QuotedIdentifierOn | True if the trigger was created with quoted identifiers on. |
| ScriptSource (Inherited from SchemaObject) |
The location of the creation script for this object if the database source is set to
scripts folder.
|
| ScriptSourceAuthorization (Inherited from SchemaObject) |
The location of the creation script for the ALTER AUTHORIZATION statement for
this object if the database source is set to scripts folder.
|
| Text | The text of the DDL trigger, if it is not a CLR DDL trigger. |
© 2003 - 2007 Red Gate Software Ltd. All Rights Reserved.
Equals