Next / Previous / Index / ITC Help System / Publications / Site map / NM Tech homepage

Deleting a Sybase index

Tech Computer Center logo

Deleting an index is a mostly painless procedure. However, you probably won't need to do it, unless you want to change which column has a clustered index or you have a index conflict such as too many nonclustered indexes (more than 249).

At the end of each command press the space-bar or press enter before continuing the next step.

  1. To delete an index, type
            Drop index
  2. Type the table name that has the index, a period, and the index name that you want to delete.
  3. Type
            go
  4. Press Enter.

If everything goes well, you see the database prompt (a period, the name of the database you are using, another period, the number one and then the greater than symbol).

For example, if you want to drop an index called zipidx from a table called rolodex, type

        drop index rolodex.zipidx go

If you see

        Msg 3701, Level 11, State 3
        Server '', Line 1
        Cannot drop the index 'rolodex.rol2', because it doesn't
            exist in the system catalogs.
you have tried to delete a table that doesn't exist. Most likely, you mis-typed the table name. Run your index command again, making sure to type the right table name.
See also: Indexing Sybase tables
Previous: Example of a Sybase composite index
Site map
Index: Keyword index to help pages
Help: New Mexico Tech Information Technology and Communications: Help System
ITC Publications
To report a problem: File a ticket
Send mail to the User consultant on duty or call them at 575-835-5437
Home: About New Mexico Tech

Maintained by John Shipman, john@nmt.edu; original by Steve Anderson
Last updated: 1997/06/23 22:39:10 UT
URL: http://www.nmt.edu/tcc/help/db/sybase/delete_index.html
QR two-dimensional bar code