Sequence

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

Item

Description

[Common items]

The following common object items may be defined for sequences:

  • AfterCreate, AfterDrop, AfterModify

  • BeforeCreate, BeforeDrop, BeforeModify

  • Create, Drop

  • Enable, EnableOwner, EnableSynonym

  • Maxlen

  • ModifiableAttributes

  • Options, DefOptions

  • Permission

  • ReversedQueries, ReversedStatements

  • SqlAttrQuery, SqlListQuery, SqlPermQuery

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

Rename

Specifies the command for renaming a sequence.

Example (Oracle 10g):

rename %OLDNAME% to %NEWNAME%

Sequence Comment

Specifies a statement for adding a sequence comment.
Parent topic: Script/Objects Category