waho
asked on
remove cluster index.
I want to remove cluster index from a table. However, it seem like I have to remove all the data only then I can remove the cluster index from that table. is there any better way. thanks.
Do you get a error message when you try to drop it? If so the only thing I can think of right now is for you to make a copy of the table. When you make a copy of the table, no indexes are created.
Nothing to stop you dropping a clustered index.
It will rebuild all the other indexes as they refer to the clustered index - maybe you are getting a problem with that - could drop all the other indexes first then add them.
If the clustered index is a primary key and referred to by foreign keys then that would stop you.
try
drop index tblname.indexname
It will rebuild all the other indexes as they refer to the clustered index - maybe you are getting a problem with that - could drop all the other indexes first then add them.
If the clustered index is a primary key and referred to by foreign keys then that would stop you.
try
drop index tblname.indexname
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
waho:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.