Dropping an Index for a SQL Anywhere Table

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.

  1. 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.
  2. Expand the Tables folder and the table that contains the index.
  3. Under the Indexes folder, find the index you want to drop.
  4. Right-click the index, and choose Drop.
Related tasks
Creating an Index for a SQL Anywhere Table
Editing an Index for a SQL Anywhere Table

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.