title: How do I check if the foreign key exists?
body: <p>I want to find a foreign key in a table, but there are changes to rename/alter the primary key.  How can I determine the foreign key and primary key in the table? </p>
  
  <p>Relevant code:</p>
  
  <pre><code>SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS 
           WHERE CONSTRAINT_NAME = 'FK_Name'
  </code></pre>