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 are system databases into sql server (2005/2008)?
How each E-R model constructs can be mapped to the relational model?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Define cross join in sql server joins?
How to download microsoft sql server 2005 express edition?
Define right outer join in sql server joins?
Explain index in sql server?
What is the difference between row_number and dense_rank?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is logon trigger?
You want to implement the many-to-many relationship while designing tables. How would you do it?
How much memory that we are using in Logshipping Concept?
What are system databases into sql server (2005/2008) : sql server database administration
Can we join two tables without primary key?
What are the main sources of data?