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

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

Please Help Members By Posting Answers For Below Questions

Which autogrowth database setting is good?

1037

What is difference between group by and having?

937

Tell me the phases a transaction has to undergo?

944

How you can get a list of all the table constraints in a database?

941

Can two tables share a primary key?

1004

How to execute the cursor queries with "open" statements?

1159

What are click through reports?

142

What is normalization process?

1149

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

980

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

1465

What is data source view or dsv? : sql server analysis services, ssas

984

What is equi join with example?

1099

Can we use pragma autonomous_transaction in trigger?

941

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

977

how to avoid cursors? : Sql server database administration

956