Interested to Buy Any Domain ? << Click Here >> for more details...
How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 34825 Views
- Semantic Space, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
Differentiate between a primary key and a unique key.
How to replace the Query Result 'Null Value' with a text ?
What are translations and its use? : sql server analysis services, ssas
Find nth lowest salary or get nth lowest salary?
Why do we use non clustered index?
What number aggregate functions are accessible there in sql?
Explain trigger classes i.e. Instead of and after trigger?
What is the purpose of sql profiler in sql server?
What is nolock?
How to get a list all databases on the sql server?
What is the fillfactor concept in indexes?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Explain the database you used in your final year project?
What are the dmvs? : sql server database administration
