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

Is it possible to update the views? If yes, how, if not, why?

983

What is temporary stored procedure?

908

When I run the sql server 2000 setup, it just hangs. What do I do?

1036

Explain index in sql server?

973

What is the server name in sql server?

971

How to generate create view script on an existing view?

956

What are different types of data sources?

955

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

937

Is the log file is a part of file group?

991

What are various aggregate functions that are available?

932

Can you use order by when defining a view?

928

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

976

What is built-in function?

948

Do you know what are the reporting services components?

936

Explain the different index configurations a table can have?

906