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 you would rewrite the sql query to return the customerid sorted numerically?

995

What is the difference between a check constraint and a rule?

1249

What is checkpoint in sql server?

1155

What are the different SQL Server Versions you have worked on?

1003

What is the return type of executeupdate ()?

906

Distinguish between commit and rollback?

959

What is the server name in sql server?

1010

What is the use of sign function?

1124

What is sparse columns of sql server 2008?

1054

What is abstracting periodical?

946

Explain the Ways to improve the performance of a sql azure database?

Mention the different authentication modes in sql server.

1055

what is normalization? : Sql server database administration

1095

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

What is sub-query in sql server?

1201