Dropping indexes

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

To drop an index (Sybase Central)

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

  2. In the left pane, double-click Indexes.

  3. Right-click the index and choose Delete.

  4. Click Yes.

To drop an index (SQL)

  1. Connect to the database as a user 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 EmployeeNames index from the database:

DROP INDEX EmployeeNames;

See DROP statement.