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 » Tables, views, and indexes » Indexes

 

Dropping an index

Drop an index when it is no longer needed, or when you need to modify the definition of a column that is part of a primary or foreign key.

Prerequisites

To drop an index on a table, you must be the owner of the table or have one of the following privileges:

  • REFERENCES privilege on the table
  • DROP ANY INDEX system privilege
  • DROP ANY OBJECT system privilege

To drop an index on a foreign key, primary key, or unique constraint, you must be the owner of the table or have one of the following privileges:

  • ALTER privilege on the table
  • ALTER ANY TABLE system privilege
  • ALTER ANY OBJECT system privilege

To drop an index on a materialized view, you must be the owner of the materialized view or have one of the following privileges:

  • DROP ANY INDEX 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. In the left pane, double-click Indexes.

  3. Right-click the index and click Delete.

  4. Click Yes.

Results

The index is dropped from the database.

Next

If you had to drop an index to delete or modify the definition of a column that is part of a primary or foreign key, you must add a new index.

 See also