Chapter 3 DBMS Reference Guide

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.

 

Copyright (C) 2007. Sybase Inc. All rights reserved.