By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,967 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,967 IT Pros & Developers. It's quick & easy.

Table rows are reordering after I delete a primary key column

P: 2
I have a simple table with a primary id column called id.
I have a need to ALTER the table and delete the primary id column. When I do the first 6 rows are reordered to the bottom of the table. I do not want them to be reordered. Any thoughts? Thanks in advance.
Sep 26 '14 #1

✓ answered by Rabbit

The primary key is usually the clustered index which determines storage order. Why would you need to delete the primary key? There's almost never a good reason to delete a primary key field.

Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,347
The primary key is usually the clustered index which determines storage order. Why would you need to delete the primary key? There's almost never a good reason to delete a primary key field.
Sep 27 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.