Not delete record the record are exsting anther table

Question

Dear sir sir i have create two table and i try to one table record existing anther table i have delete first table record then record are not delete because first table data are existing second table please help me how to solve this

Ravi Patel · Answer

Hi  if your table have proper relationship. primary key and foreign key. right click on second table(which contain the primary key of first table) click on Design and then go to Relationship Icon click on it and make Delete Rule as Cascade. if you are deleting the record of first table all related table should be deleted.

Amit Singh · Answer

1. delete from tableA where exists ( select 1 from tableB where email = tableA.email ) 2. delete tableA from tableA inner join tableB on tableA.email = tableB.email