August 4, 2010 at 1:03 pm
Hi all,
In SQL 2K (or SQL 2K8), is it possible to programmatically alter the PK constraints on the tables from nonclustered to clustered? When they're referenced by FKs?
Or do I have to climb all the way down the referential tree, and drop and re-create the PKs from the bottom up?
We're upgrading to SQL 2K8, and the lack of clustered indexes is becoming apparent.
Thanks!
P
August 4, 2010 at 8:47 pm
Don't think you can do it without dropping all the FK's and then dropping and recreating the PK and then re-adding the FK's
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 5, 2010 at 5:47 am
Thanks Jack,
That's what I was afraid of.
Ah well, it needs doing, so....
P
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy