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

Name few of the dcl commands in sql?

951

How to Update from select query in sql server?

992

What are commonly used mssql functions in php?

997

How to count groups returned with the group by clause in ms sql server?

1005

Explain about Normalization?

1011

What is measure group, measure? : sql server analysis services, ssas

959

What do you mean by subquery?

1018

How to execute a sql statement using odbc_exec()?

1056

How to disable a login name in ms sql server?

1059

Explain magic tables in sql server?

981

What are horizontal and vertical scaling?

170

Can multiple columns be used in sql group by clause in ms sql server?

984

How to backup encryption key ?

167

User wants only to display only pdf as export option in report manager. How to achieve this?

247

How to change the system date and time from SQL Plus Terminal ?

1151