title: Can the same column have primary key & foreign key constraint to another column
body: <p>Can the same column have primary key &amp; foreign key constraint to another column?</p>
  
  <pre><code>Table1: ID - Primary column, foreign key constraint for Table2 ID
  Table2: ID - Primary column, Name 
  </code></pre>
  
  <p>Will this be an issue if i try to delete table1 data?</p>
  
  <pre><code>Delete from table1 where ID=1000;
  </code></pre>
  
  <p>Thanks.</p>