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

How do I install only the client tools of sql server 2000?

1061

What is the difference between index seek vs. Index scan?

1021

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

878

last function used in MS Access to convert sql what function will use in sql

2069

What is the difference between composite index and covering index?

948

Scalability, Availability, Integration with internet, etc.)?

2874

What will be the maximum number of index per table?

997

Which tcl commands are available on the sql server?

1077

Explain about sql server login?

1078

What command would you use to add a column to a table in sql server?

1305

What is analysis service repository?

1023

What is logshipping and its purpose?

989

Introduction of rollup clause using sum and group by clause?

958

Explain optimistic and pessimistic concurrency?

991

What is meant by indexing files?

1036