title: Referential integrity
body: <p>which method should one follow  to drop master table if its primary key is referenced by a foriegn key in some other table?</p>
  
  <p>i know about on delete cascade, is there any other way?  which is the best practice</p>
  
  <p>Thanks</p>