how to delete parent and child records at time in Sql server

Question

hi all,

 I want to delete records from parent and child tables when there is foreign key relation between parent and child tables using stored procedure

thanks