How to mintain ref integrity when you change the primary keys?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • newnauk
    New Member
    • Aug 2010
    • 2

    How to mintain ref integrity when you change the primary keys?

    I've creatd an ADO.NET app that reads from an MS Access database and I like to modify the primary keys of all the data tables before copying them over to another DB server. When you change the primary keys on a parent table what is the best way to to update the referential integrity to the related child table?

    Thanks,

    Andrew
Working...