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 the difference between cube operator and rollup operator? : SQL Server Architecture
What is merge statement?
Can we shrink data file in sql server?
Explain few of the new features of sql server 2008 management studio
Can we linked SharePoint to a SQL database?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
How much memory that we are using in Logshipping Concept?
How can you start sql server in different modes?
Explain in details security in SQL azure?
How to use order by with union operators in ms sql server?
Can you use order by when defining a view?
What is a result set object returned by mssql_query()?
What is xdr?
What is 4nf in normalization form?
Why do we use functions?