How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 32990 Views
- Semantic Space, I also Faced
- E-Mail Answers
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 cursors? And what are the different types of cursor?
What is a mixed extent?
how we use window authentication connection with sql server.?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is a document index?
What is shared lock?
Explain what is dbcc?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is the difference between clustered index and primary key?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are the operating modes in which database mirroring runs?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What command is used to delete a table from the database in the sql server and how?
What is a result set object returned by odbc_exec()?
How to create view in stored procedure sql server?
