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 are the Advantages of using CTE in sql server?
Explain what are various ways to enhance the ssrs report?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
How to configure odbc dsn with different port numbers?
What is a cube? : sql server analysis services, ssas
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Do you know the policy based administration feature of sql server 2008?
What is the parse query button used for?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Where can you find the error log information? : sql server database administration
How do I create a stored procedure in dbml?
What encryption security is available in sql azure?
what are the different types of replication you can set up in sql server? : Sql server database administration
Explain the flow of creating a cube? : sql server analysis services, ssas
What is xml datatype?