delete from child_table where values=... on delete cascade.. U have to se

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

Question Posted / arijitnit

Answer Posted / arijitnit

delete from child_table where values=...
on delete cascade..
U have to set the foreign key as the parent super key

Is This Answer Correct ?

11 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are diverse clauses that form a part of sql?

1108

What are the instances when triggers are appropriate?

1017

Define cursor locking

1058

What is a constant or literal in ms sql server?

1096

Can you explain what is sql server english query?

1052

Introduction of rollup clause using sum and group by clause?

1009

What authentication modes does sql server support?

1147

What is indexing a document?

1085

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1104

What is database black box testing?

1070

What are user-defined functions (udfs) in sql server?

1048

Which are the third-party tools used in sql server and why would you use them?

958

can a table be moved to different filegroup? : Sql server administration

1016

What is the default sql server instance name?

1084

What is table-valued sub query?

1026