title: SQL Alter: add multiple FKs?
body: <p><a href="http://www.1keydata.com/sql/sql-foreign-key.html" rel="noreferrer">From here</a></p>
  
  <pre><code>ALTER TABLE ORDERS
  ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID); 
  </code></pre>
  
  <p>How do I add several keys with SQL Server? Is it something like the below? (I cant test ATM and unfortunately I have no way to test queries unless I run it through code)</p>
  
  <pre><code>ALTER TABLE ORDERS
  ADD FOREIGN KEY (customer_sid) REFERENCES CUSTOMER(SID), 
  ADD FOREIGN KEY (customer_sid2) REFERENCES CUSTOMER(SID2);
  </code></pre>
  
  <p>or is it like</p>
  
  <pre><code>ALTER TABLE ORDERS
  ADD FOREIGN KEY (customer_sid, customer_sid2) REFERENCES CUSTOMER(SID, SID2)
  </code></pre>