ASA SQL User's Guide
  Working with Database Objects
    Working with indexes

Dropping indexes

If an index is no longer required, you can remove it from the database in Sybase Central or in Interactive SQL.

To drop an index (Sybase Central)

1. Connect to a database with DBA authority or as the owner of the table on which the index is created.

2. In the left pane, open the Indexes folder.

3. Right-click the desired index and choose Delete from the popup menu.

To drop an index (SQL)

1. Connect to a database with DBA authority or as the owner of the table associated with the index.

2. Execute a DROP INDEX statement.

Example 

The following statement removes the index from the database:

DROP INDEX EmpNames

For more information, see DROP statement.