Tuesday, July 3, 2007

Index on Primary Key

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
 
 
 

No comments: