I think using ON DELETE CASCADE we can delete the records from both chil

How to write query to Delete the records in child table
and corresponding records in parent table

Question Posted / satyanarayana

Answer Posted / satyanarayana

I think using ON DELETE CASCADE we can delete the records
from both child and parent table

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1027

What is a trigger what are the advantages of trigger?

977

How to implement service broker?

983

can we have a nested transaction? : Sql server database administration

1055

What are dml triggers and types of dml triggers?

963

What is the cartesian product of the table?

943

Does index slows down insert statements?

984

What are the difference between “where” and “having” clause in sql server?

1051

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

933

What are the advantages of passing name-value pairs as parameters?

1151

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1194

Explain how to maintain a fill factor in existing indexes?

979

What are the types of database schema? : sql server analysis services, ssas

1107

Define primary key?

1115

How do I partition a table in sql server?

1021