How to write query to Delete the records in child table
and corresponding records in parent table
Answer Posted / satyanarayana
I think using ON DELETE CASCADE we can delete the records
from both child and parent table
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the purpose of optimization?
Explain what are magic tables in sql server?
What is the purpose of floor function?
What do you mean by the term 'normalization'?
What is the stuff?
Are resultset updatable?
What is database architecture? : SQL Server Architecture
How will you know when statistics on a table are obsolete?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How are the unique and primary key constraints different?
Which language rdl files made of?
Can we delete data from a view?
Explain throw statement in sql server 2008?
How do you size a resultset?
how to do partition in sqlserver