title: SQL Server ON DELETE Trigger
body: <p>I'm trying to create a basic database trigger that conditionally deletes rows from database1.table1 when a row from database2.table2 is deleted. I'm new to triggers and was hoping to learn the best way to accomplish this. This is what I have so far. Suggestions?</p>
  
  <pre><code>CREATE TRIGGER sampleTrigger
      ON database1.dbo.table1
      FOR DELETE
  AS
      IF EXISTS (SELECT foo
                 FROM database2.dbo.table2
                 WHERE id = deleted.id
                 AND bar = 4)
  
  -- If there is a row that exists in database2.dbo.table2 
  -- matching the id of the deleted row and bar=4, delete 
  -- it as well.
  
  -- DELETE STATEMENT?
  
  GO
  </code></pre>