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.
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.
Maintained by John Shipman, firstname.lastname@example.org;
original by Steve Anderson
Last updated: 1997/06/23 22:39:10 UT