title: How to add surrogate key to related tables?
body: <p>I need to add a auto-inc surrogate key to three tables in my data warehouse:</p>
  <p>Note: These are not the real table names</p>
  <blockquote>
  <p>JakMaster (JakMasterId, Date) (PK) <strong>Note: JakMasterId is varchar(60)</strong></p>
  <p>JakToRoad (JakMasterId, Date) (FK)</p>
  <p>JakToBig  (JakMasterId, Date) (FK)</p>
  </blockquote>
  <p>What steps should I take to add a surrogate key to these three tables so that the new keys reference each other correctly?</p>
  <p>Thanks!</p>