Trigger Properties

Trigger Object Properties Methods Lists Collections

Property Description

Application
    Application
    Write: No
The Application object.
CreateDate
    String
    Write: No
The date and time the trigger was created.
ID
    Long
    Write: No
The object ID of the trigger.
Name
    Identifier
    Write: Yes
The name of the trigger.
Owner
    Identifier
    Write: No
The user who created the trigger.
Parent
    Table
    Write: No
The Table object.
SystemObject
    Boolean
    Write: No
Indicates if this is a SQL Server system trigger. If True, this is a SQL Server system trigger. If False, this trigger was created by a user.
Text
    String
    Write: Before Add
The Transact-SQL statements used to create the trigger.
Type
    SQLOLE_TRIGGER_TYPE
    Write: Before Add
The type of trigger.
TypeOf
    SQLOLE_OBJECT_TYPE
    Write: No
The type of object.
UserData
    Long
    Write: Yes
Temporary storage space contained in this object for private use by the application. SQL-DMO does not use this property.