title: Cascade delete query on clients table
body: <p>I am trying to configure the CLIENTS table on my database such that if an employee is deleted from the EMP table any associated clients are automatically deleted from the CLIENTS table.</p>
  
  <p>This is what I've tried so far.</p>
  
  <pre><code>ALTER TABLE clients
  MODIFY empno REFERENCES emp(empno) ON DELETE CASCADE
  </code></pre>
  
  <p>Unfortunately this returns a <strong>near "MODIFY": syntax error</strong> every time I try to run it. Any idea what is going wrong?</p>
  
  <p>Thanks in advance.</p>