title: How do I use cascade delete with SQL Server?
body: <p>I have 2 tables: T1 and T2, they are existing tables with data.  We have a one to many relationship between T1 and T2.  How do I alter the table definitions to perform cascading delete in SQL Server when a record from T1 is deleted, all associated records in T2 also deleted. </p>
  
  <p>The foreign constraint is in place between them. I don't want to drop the tables or create a trigger to do the deletion for T2. For example, when I delete an employee, all the review record should be gone, too.</p>
  
  <p>T1 - Employee,</p>
  
  <pre><code>Employee ID      
  Name
  Status
  </code></pre>
  
  <p>T2 - Performance Reviews,</p>
  
  <pre><code>Employee ID - 2009 Review
  Employee ID - 2010 Review
  </code></pre>