What is the use of CASCADE CONSTRAINTS?

Answer Posted / kunal sain

to drop the constraint from child table when dropping the
constraint from parent table.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default fill factor value?

581


What is sql server schema compare? How we can compare two database schemas?

562


What are the different editions available in sql server 2000?

587


what is difference between NULL and ISNULL in SQL Server 2008?

579


Can a unique index be created on a column, which contains null?

523






what is the difference between a primary key and a unique key? : Sql server database administration

529


How to make conditional sum in ssrs?

132


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

593


How can you control the amount of free space in your index pages?

613


What are partitioned views?

581


What is spid in sql server profiler?

538


what is the difference between Tabular and Matrix report?

124


what type of index will get created after executing the above statement? : Sql server database administration

537


How to use copy and concatenate commands in SQL?

601


What are cursors stored procedures and triggers?

514