Dropping an index

You can 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

You must have DBA authority or be the owner of the table on which the index is created.

Context and remarks

Many.

 Drop an index using Sybase Central

  1. Use the SQL Anywhere 12 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 in order to delete or modify the definition of a column that is part of a primary or foreign key, you need to add a new index.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1