Dropping an index deletes it from the database.
You can use either Sybase Central or Interactive SQL to perform this task.
In Sybase Central, you can perform these tasks while working with a selected database.
Connect to the UltraLite database.
Open the Indexes folder.
Select the desired index and then choose Edit > Delete.
In Interactive SQL, deleting a table is also called dropping it. You can perform these tasks with the DROP INDEX statement.
Connect to a database.
Execute a DROP INDEX statement.
Example The following statement removes the EmployeeNames index from the database:
DROP INDEX EmployeeNames