What is the use of CASCADE CONSTRAINTS?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kunal sain
to drop the constraint from child table when dropping the
constraint from parent table.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / nitesh
It is mainly used in referential integrity constraints.
When you use primary key/candidate key of one relation(say,
r1) as foreign key in other relation(say, r2), you want
changes made to primary key/candidate key of r1 must reflect
in foreign key of r2. And this can be achieved by CASCADE
constraint.
eg. consider two relations account, branch(with primary key
branch_name)
create table account(.....
foreign key branch_name references branch
on delete cascade
on update cascade
..........)
Is This Answer Correct ? | 0 Yes | 0 No |
what is Constraint? How many types of constraints in SQL ?
38 Answers HCL, IBM, NIIT, Wipro,
How can you tell if a database object is invalid?
What are the advantages dts has over bcp?
Explain about Joins?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
5 Answers Aptech, HCL, Perpetual, SAIC,
Explain what is use of dbcc commands?
What are the differences between left join and inner join in sql server?
What are the recovery models for a database?
What is the use of floor function in sql server?
Can we use where clause in union?
Please explain what is “asynchronous” communication in sql server service broker?
What is sql server replication? : sql server replication