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 is usually the first word in a sql query?

1068

How to create an multi-statement table-valued function?

938

What is the difference between set and select?

1014

What is intellisense?

988

Is null in sql server?

938

What are the steps you must follow to hide sql server instances?

928

What is filestream?

942

tell me the disaster recovery plan

2455

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

956

What is difference between getdate and sysdatetime in sql server 2008?

999

between cast and convert which function would you prefer and why?

915

Explain different types of self contained sub query?

948

What is default port number for sql server 2000?

993

What is the most common type of join?

910

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

147