Deleting a sequence modifies a database's schema.

To delete a sequence:

  1. Make sure that the database containing the sequences you want to delete is the current working database.
  2. Choose Schema > Sequence Editor. The Sequence Editor lists all the sequences defined for the working database and the attributes for the sequence that is selected.
  3. Select the sequence you want to delete.
  4. Choose the Delete option from the menu at the bottom of the window. The Sequence Editor prompts you to verify that you want to remove the sequence.
  5. Choose Yes to delete the sequence. The Sequence Editor main window appears.
  6. Choose Exit. The Data Dictionary main window appears.