If an index is no longer required, you can delete it from the database in Sybase Central or in Interactive SQL.
Connect to the database as a DBA user or as the owner of the table on which the index is created.
In the left pane, open the Indexes folder.
Select the desired index and then choose Edit > Delete.
Connect to the database as a DBA user or as the owner of the table associated with the index.
Execute a DROP INDEX statement.
The following statement removes the EmployeeNames index from the database:
DROP INDEX EmployeeNames;
For more information, see DROP statement.