Dropping an Index for a Sybase IQ Table

Drop a Sybase IQ 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 Sybase IQ Table
Editing an Index for a Sybase IQ Table
Generating Index Advice Using the Index Advisor


Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com