How do I drop the index related to a primary key? DROP INDEX doesn't work.
Answer : A simple & direct answer is we can't do it directly. (according to my knowledge)
There are two work-arounds:
1. Create a clustered Index on another column & delete clustered index from that column.
2. Delete the constarint
sp_helpconstraint table_name
ALTER TABLE [database.[owner].]table_name
DROP CONSTRAINT constraint_name
DROP CONSTRAINT constraint_name
No comments:
Post a Comment