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

How to assign new column names in a view?

862

How to send a ssrs report from ssis?

166

Define msdb database?

972

How to insert multiple rows with a subquery?

1059

What are the types of stored procedures in an sql server?

934

Introduction of rollup clause using sum and group by clause?

898

What is dynamic cursor in SQL SERVER?

1000

Does the order of columns in update statements matter?

857

Does partitioning help performance?

886

Why use stored procedures in sql server?

951

What are sql server functions?

935

What is SQL Server?

1147

How can you tell if a database object is invalid?

1012

What is the purpose of update statistics and scope_identity() function?

1046

How are the exceptions handled in sql server programming?

996