delete from child_table, parent_table where child_table.parent_id=parent

How to write query to Delete the records in child table
and corresponding records in parent table

Question Posted / vaishali

11 Answers
35308 Views
Semantic Space, I also Faced
E-Mail Answers

Answer Posted / vaishali

delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id

Is This Answer Correct ?

14 Yes

26 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to rebuild all indexes on a single table?

1104

What is row-level compre?

1045

What is dbcc?

1177

What is a data source or ds? : sql server analysis services, ssas

1049

Explain identity in sql server?

1048

In what three ways is the return statement used in a stored procedure?

1060

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2847

What is deploy, process and build? : sql server analysis services, ssas

1150

How to insert and update data into a table with "insert" and "update" statements?

1035

If we delete pack Spec what will be the status of pack Body ?

1520

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1894

What happens if null values are involved in arithmetic operations?

1041

Explain primary key in sql server?

1069

How to find the source of a table in sql server?

1032

Can you please explain the difference between primary keys and foreign keys?

1165