title: Why do I get "Incorrect syntax near the keyword 'FOR'"?
body: <p>I have two tables <code>person</code> and <code>customer</code>. When deleting from <code>person</code> I want to delete from <code>customer</code>:</p>
  
  <pre><code>CREATE TRIGGER DELCUS
  ON Person
  AFTER DELETE
  FOR EACH ROW
  begin
  DELETE FROM customer
  WHERE customer.PersonID_Fk=Person.PersonId;
  end 
  </code></pre>
  
  <p>Here is the error I get:</p>
  
  <pre><code>Msg 156, Level 15, State 1, Procedure DELCUS, Line 5
  Incorrect syntax near the keyword 'FOR'.
  </code></pre>
  
  <p>Why can't it read for each row?</p>