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 INDEX statement.