title: sql delete with foreign key constraint
body: <p>I have three tables, one of them is a relation table, for example:</p>
  
  <p>Table <strong>People</strong> has primary key : <em>peopleid</em>;<br>
  Table <strong>Pet</strong> has primary key : <em>petid</em>;<br>
  Table <strong>Own</strong> has two foreign keys: <em>peopleid</em> and <em>petid</em>, they together serve as the primary key of table <strong>Own</strong></p>
  
  <p>Now <br>
  I'm trying to delete a person from Table People given <em>peopleid</em>, meanwhile, the pets this person own should be deleted, as well as the relationship stored in table <strong>Own</strong></p>
  
  <p>Please shed some light, thanks in advance!</p>
  
  <p><strong>Edit:</strong> My question is how to write the sql to achieve this. </p>