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 understand by intent locks?

Tell me what is normalization? Explain different forms of normalization?

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

What is data modeling and Reterminal integrity?

What is primary key index?

What do you mean by cardinality?

Do you know what are various aggregate functions that are available?

What is SQL Server?

How can I create a report based on a query? : sql server management studio

what stored procedure can you use to display the current processes? : Sql server administration

Which are the new data types introduced in sql server 2008?

What is read committed?

For more SQL Server Interview Questions Click Here