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
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is partition in sql server?
Explain the difference between delete,drop and truncate in SQL Server?
what are the Prerequisites for Replication?
what are the reporting service components in SSRS?
How can you append an identity column to a temporary table?
Explain Capacity planning to create a database? and how to monitor it?
What is implicit cursors?
how we use window authentication connection with sql server.?
What security features are available for stored procedure?
Define right outer join?
What is sql server programming?
Can we add our custom code in ssis?
How to use clusters?
What is rtm version in sql server?