Drop a SQL Anywhere index definition from a database.
PrerequisitesÂ
Before you can drop an index, be sure the data server that contains the index is running,
and you created and established a connection to it.
In the Databases folder in Enterprise Explorer, under the database connection profile,
expand
the
tree for a database, expand the
Schemas folder and then the tree for the appropriate schema owner.
Expand the Tables folder and the table that contains the index.
Under the
Indexes folder, find the index you want to
drop.