Deleting a Sybase index

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.

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