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


Learn more