title: add to primary key without dropping foreign key references
body: <p>I have a table with a primary key that I would like to add another column to. The problem is, when I add this, Sql Server drops all foreign key references to that table.</p>
  
  <p>Is there any way to fix this? (or maybe even a tool that refactors this)?</p>