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.

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.