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.

Prérequis

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
 Task

  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.

Résultat

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
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0