Table rows are reordering after I delete a primary key column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • beckjoh
    New Member
    • Sep 2014
    • 2

    #1

    Table rows are reordering after I delete a primary key column

    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.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    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.

    Comment

    Working...