DBMS Trigger

The DBMS Trigger category is located in the Root > Script > Objects category, and can contain the following items that define how DBMS triggers are modeled for your DBMS.

Item

Description

[Common items]

The following common object items may be defined for DBMS triggers:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Alter, AlterStatementList, AlterDBIgnored

  • Enable, EnableOwner

  • Header, Footer

  • Maxlen

  • ModifiableAttributes

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery

For a description of each of these common items, see Common object items.

EventDelimiter

Specifies a character to separate multiple trigger events.

Events_scope

Specifies a list of trigger event attributes to populate the Event list on the Definition tab of Trigger property sheets for the selected scope, for example, schema, database, server.

Scope

Specifies a list of available scopes for the DBMS trigger. Each scope must have an associated Events_scope item.

Time

Specifies a list of trigger time attributes to populate the Time list on the Definition tab of Trigger property sheets.

Example:

Before
After

Trigger Comment

Specifies a statement for adding a trigger comment.