Model Database Sequences
Database Sequences are a feature that some DBMS products implement to provide users with a mechanism generate unique values. In the Database Builder, you create and define database Sequences as individual objects.
Access Tools | Database Builder | Right-click on Sequences Package | Add new Sequence
A database Sequence element is immediately added to the Package, with the name highlighted for change. Type an appropriate name.
To define the database Sequence, double-click on it. The Sequence: <sequence name> dialog displays.
|·||The Database field defaults to the DBMS for which you are defining the database|
|·||In the Notes field, type some notes on, or a description of, the Sequence|
|·||In the Sequence definition field, type the full Sequence definition; the code editor provides Intelli-sense for basic SQL keywords and functions|
To delete a database Sequence, right-click on the Sequence name and click on the Delete <sequence name> option. A prompt displays to confirm deletion of the Sequence and its contents; click on the Yes button.
|·||If you create a database Sequence element external to the Database Builder, in any part of the model other than the Sequences Package, that Sequence element is automatically reassigned to the Sequences Package|
|·||Database Sequences created as individual objects are represented in the model hierarchy in the Database Builder as Class element icons; if you have database Sequences as operations of a container Class (created external to the Database Builder) they are represented in the model hierarchy as Class element icons with a pink 'operation' icon in the bottom right corner|