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
When to use Inner join & when to use subquery?
Can we store videos inside the sql server table?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
what is denormalization? : Sql server database administration
What is SQL Azure?
What is a dbms wizard?
What is transaction server implicit?
Can two different columns be merged into single column? Show practically?
What do you mean by 'normalization'?
What is awe?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What do you understand by mirroring and mention the advantages of the mirroring?
What are the different types of stored procedures?
What is model database in sql server?