Solved

I want to drop the just the Clustered Index on the Primary Key not the Primary Key itself.

Posted on 2011-02-25
4
382 Views
Last Modified: 2012-05-11
I want to drop the just the Clustered Index on the Primary Key not the Primary Key itself.


I have read the third method on link: http://www.dbtalks.com/UploadFile/sapnabeniwal01/339/
0
Comment
Question by:Mr_Shaw
  • 3
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 34978932
you cannot drop the index for a primary key.
you cannot change a clustered index to non-clustered without dropping it

conclusion:
you have to drop the primary key (and before that, any foreign keys pointing to it),
recreate the primary key with a non-clustered index
finally recreate the foreign keys dropped before
0
 

Author Comment

by:Mr_Shaw
ID: 34978957
Is there a quick way which I can out all the foreign key which link to my primary key which I am going to drop?
0
 

Author Comment

by:Mr_Shaw
ID: 34979055
I found a link to list all foreign keys.

http://www.mssqltips.com/tip.asp?tip=1151
0
 

Author Closing Comment

by:Mr_Shaw
ID: 34979056
thanks
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dynamic SQL select query 4 37
SQL Syntax Grouping Sum question 7 24
RAISERROR WITH NOWAIT 2 16
too many installs coming along with SQL 2016? 1 16
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question