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

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

Can we perform backup restore operation on tempdb?

what is denormalization and when would you go for it? : Sql server database administration

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

What is implicit cursors?

What is full form of XP ?

Explain the commands in sql server?

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

How will u get 5 years back record?

What is the diffrence between update_one and auto_fix?

What are the 3 types of schema?

For more SQL Server Interview Questions Click Here