Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Transactions and isolation levels » Primary key generation and concurrency » Use of a sequence to generate unique values


Dropping a sequence

You can use Sybase Central to drop a sequence.


You must be the owner of the sequence or have one of the following privileges:

  • DROP ANY SEQUENCE system privilege
  • DROP ANY OBJECT system privilege
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Right-click a sequence generator and then click Delete.


The sequence is dropped from the database. When you drop a sequence, all synonyms for the name of the sequence are dropped automatically by the database server.

 See also