Answer Posted / naresh
If you specify this option, later when you delete a row in
the parent table, the database server also deletes any rows
associated with that row (foreign keys) in a child table.
The principal advantage to the cascading-deletes feature is
that it allows you to reduce the quantity of SQL statements
you need to perform delete actions.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
what is normalization? Explain different levels of normalization? : Sql server database administration
How to delete a database in ms sql server?
What is normalization and denormalization in sql server?
Create and insert into temp table in sql server?
Can group functions be used in the order by clause in ms sql server?
What are different types of subquery?
What are key constraints?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Tell me in brief how sql server enhances scalability of the database system?
Is sql server is free?
What to perform pattern match with the like operator?
Difference between report and query parameter.
Does the order of columns in update statements matter?
What is the chart in report?
How to make conditional sum in ssrs?
