Interested to Buy Any Domain ? << Click Here >> for more details...
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
Do you know what is blocking?
How to scale out a federation by Sql statement?
Does the order of columns in update statements matter?
What are scalar functions in sql?
What is indexing in sql server with example?
What is the importance of three tier architecture?
Describe the functionalities that views support.
Explain various On-Delete options in a DB table. Which is the default option?
What happens if null values are involved in boolean operations?
Does sql server 2000 clustering support load balancing?
Explain the etl (extraction, transformation, and loading)?
Can sql servers linked to other servers?
What is normalization and what are the advantages of it?
What are approximate numeric data types in ms sql server?
What are constraints?
