title: How to change Foreign Key name?
body: <p>I am currently creating new tables in my SQL Server database. I am renaming the old tables, so also the foreign key constraints.</p>
  
  <p>To use the Adventureworks DB as an example the SalesOrderDetail table has FK_SalesOrderDetail_SalesOrderHeader_SalesOrderId (which links to the SalesOrderHeader table).</p>
  
  <p>Is is changing the name of this foreign key sufficient or do I also need to change the foreign key reference in the SalesOrderHeader Table?</p>