Answer / arijitnit

delete from child_table where values=...
on delete cascade..
U have to set the foreign key as the parent super key

Answer / dileep

Better you create a Trigger on child table like this one

CREATE TRIGGER trDelTrigger ON [dbo].[ChildTable]
FOR DELETE
AS
DELETE FROM ParentTable WHERE ParentTable.IdColumn=
(SELECT Deleted.IdColumn FROM Deleted)

Answer / krishna evsg

With help of temporary tables , we can do it made easy

create table #temp_ParentIDs
(
ID int
)
GO

Insert into #temp_ParentIDs
(ID)
select Parent_id from child_tab
GO

delete from Child_tab
GO

delete from parent_tab where parent_Id In(select * from
#temp_ParentIDs)
GO

Answer / krishnakumar

create table employee(id int references authors(au_id) ON
DELETE CASCADE,firstname(30))



this is chilld table .in this query use on first child table
constraints values delete next parent table constrains value
delete ... this is ON DELETE CASCADE CONCEPT

Answer / chaitanya

***********
Delete from P_table where P_Id=C_Id
***********

This is only aplicable if you have defined the foreign key
in the child table with the constraint on Delete Cascade.
Else you will get a Integration error.

Answer / satyanarayana

I think using ON DELETE CASCADE we can delete the records
from both child and parent table

Answer / tester

Hi vaishali have u executed the query it is not working

Answer / surya

use this:

DELETE FROM childTable WHERE EXISTS(SELECT id FROM
parentTable WHERE parentTable .id = childTable .id where id = 1)

Answer / sanjay

delete details from details inner join master on
details.keyid=master.keyid

Answer / zackziss

delete from c from child c inner join parent
on c.childid = parentid

What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

What is primary key and example?

1 Answers  

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

1 Answers  

Can we use where clause in union?

1 Answers  

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

What are the five characteristics of good data?

1 Answers  

How to get a list of columns in a view using "sys.columns" in ms sql server?

1 Answers  

What is partition in sql server?

1 Answers  

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

1 Answers  

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers