delet record from more than one table

Question

i m using a gridview which is binded. i want to delete rows from multiple tables . i m able to delete from one table using delete command but not for multiple tables. can anyone help me.

Santhosh Kumar Jayaraman · Answer

You have to modify your table structure ..add on cascade as i did in your child table

Muhammad younas · Answer

i m using command field and delete command. and i want to delete a record from multiple tables.

Santhosh Kumar Jayaraman · Answer

create table emp (id int primary key name varchar(10) ) create table EMpROle (id int primary key Role varchar(10) foreign key (id) references emp(id) on delete cascade ) insert into emp values (1'A') insert into emp values (2'AA') insert into emp values (3'AAA') insert into EMpROle values(1'Manager') insert into EMpROle values(2'Accountant') insert into EMpROle values(3'Director') --you can see 3 rows select * from emprole --am deleting only from table emp delete from emp where id=3 --Now only 2 rows select * from emprole