Physical Modeling › Oracle Physical Property Editors › Oracle Sequence Editor

Oracle Sequence Editor

Use the Oracle Sequence Editor to add or edit the parameters for a sequence.

You can open the Oracle Sequence Editor in one of the following ways:

• Select Sequences from the Database menu
• Right-click a sequence in the Model Explorer and select Properties
• Single-click a sequence in the Model Explorer and click the Property Editor icon

The Oracle Sequence Editor dialog includes the following tabs:

General Add and specify the parameters for a sequence.

Comment Add or edit comments for a sequence.

Synonym Create, edit, or delete synonyms that apply to the selected sequence.

UDP Enter user-defined property values for a sequence.

The following describes all of the other options available in this dialog:

• Sequence

  A list box that displays all available sequences in the current model.

• Owner

  Assigns a database Owner to the selected sequence.

• New

  Opens the Create Sequence dialog where you can specify the name for the new sequence.

• Rename

  Opens the Rename Sequence <Sequence Name> dialog where you can assign a different name to the sequence.

• Delete

  Select a sequence from the Sequence list box that you want to delete, and click the Delete button.

• Generate

  Generates DDL for this object during Forward Engineering. If you do not select the check box, no DDL will be generated for this object during Forward Engineering.

• DB Sync

  Starts the Complete Compare task so you can synchronize the physical objects defined in your model with the information stored on the server.