title: What's the different between RESTRICT and NO ACTION?
body: <p>I'm trying to make a FK on a column, and now I'm thinking when exactly should I use <code>ON DELETE RESTRICT</code>? <em>(or <code>ON UPDATE RESTRICT</code>)</em>. Isn't it the same as <code>NO ACTION</code>?</p>
  
  <p>Well <code>ON DELETE RESTRICT</code> means you can't delete a given parent row if a child row exists that references the value for that parent row. If the parent row has no referencing child rows, then you can delete that parent row. Well its definition is the default behavior for a foreign key anyway.</p>
  
  <p>Am I missing something?</p>