Sybase 12.4.2 - Manual (Page 154)

Working with indexes
134
Figure 3-1: sp_iqindex results
If you omit the table name from the command, sp_iqindex displays this
information for all tables in the database.
Removing indexes
If a column index or join index is no longer required, you can remove it from
the database using the
DROP statement. You can also drop indexes in Sybase
Central by clicking the table name, right-clicking to display options, and
clicking the Delete option. Before you drop a join index, see “Modifying tables
included in a join index” for special requirements.