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

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

Question Posted / tester

Answers were Sorted based on User's Feedback

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

Answer / vaishali

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

Is This Answer Correct ?

14 Yes

26 No

More SQL Server Interview Questions

What is a job?

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

Explain Normalization and DE normalization

What is a view in sql?

What is ems sql management studio? : sql server management studio

What is the command used to check locks in microsoft sql server?

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

What are the new data types are introduced in sql 2000?

What is apply operator in sql?

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?

What's the difference between a primary key and a unique key?

For more SQL Server Interview Questions Click Here