Show TOC

Deleting SequencesLocate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You are the owner of the sequence or have DROPIN privilege for the schema to which the sequence belongs.

    More information: SQL Reference Manual, Privilege Specification for a Schema (schema_priv_spec)

  • The database is in the ONLINE operational state.

Procedure

  1. Select the sequence in the explorer tree.
  2. In the context menu of the sequence, choose Delete.

Next Steps

SQL Reference Manual, DROP SEQUENCE Statement (drop_sequence_statement)