title: How to Update the primary key of table which is referenced as foreign key in another table?
body: <p>Suppose a </p>
  
  <pre><code>Table "Person" having 
      "SSN",
      "Name",
      "Address"
  </code></pre>
  
  <p>and another </p>
  
  <pre><code>Table "Contacts" having
      "Contact_ID",
      "Contact_Type",
      "SSN" (primary key of Person)
  </code></pre>
  
  <p>similarly </p>
  
  <pre><code>Table "Records" having
      "Record_ID",
      "Record_Type",
      "SSN" (primary key of Person)
  </code></pre>
  
  <p>Now i want that when i change or update SSN in person table that accordingly changes in other 2 tables.</p>
  
  <ol>
  <li>If anyone can help me with a trigger for that </li>
  <li>Or how to pass foreign key constraints for tables</li>
  </ol>