Dropping an Index for an ASE Table

Drop an 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 Databases folder, and then expand the tree for a database 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 an ASE Table
Editing an Index for an ASE Table

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com