will a primary key change be reflected in the existing records?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lrg
    New Member
    • Jun 2007
    • 8

    will a primary key change be reflected in the existing records?

    i created a table with 2 columns as primary key and inserted 100 records. now i want to include one more column as primary key. Will this change be reflected in the existing records or i've to reinsert these records so as to make the change in primary key reflect on these 100 records?

    thanks in advance,
    lrg.
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Have you created a composit primary key ?

    Comment

    • lrg
      New Member
      • Jun 2007
      • 8

      #3
      earlier i created it as a composite key with 2 columns.. now i want 2 include one more column to it

      Comment

      • Saii
        Recognized Expert New Member
        • Apr 2007
        • 145

        #4
        yes, you can alter provided adding the new column does not violate the PK.

        Comment

        Working...