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 do you mean by COLLATION?

How do I open port 1433?

What is the filtered index?

Describe in brief sql server monitoring ways.

what is the Ticketing tool used in Wipro technologies at Bangalore...???

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

Does server sql treat char as a variable-length or fixed-length column?

Difference between LEN() and DATALENGTH() in sql server ?

How you can move data or databases between servers and databases in sql server?

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

what is isolation level at dead lock?

Create and insert into temp table in sql server?

For more SQL Server Interview Questions Click Here