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

What is report server project?

147

What are the reporting services components?

142

How to drop an existing table?

1000

What are the advantages of using cte?

1013

what are the disadvantages of cursors? : Sql server database administration

1029

How to verify a login name with sqlcmd tool?

1217

What is replication and database mirroring?

1047

What is tablesample?

1110

Explain the difference between HTTP and HTTPS in database?

1030

When you should use a low fill factor?

993

What is transaction server implicit?

1008

What is built-in/administrator?

1003

What is after dml trigger?

1016

What is de-normalization and what are some of the examples of it?

976

What part does database design plays a role in performance of an sql server-based application?

980