Answer Posted / 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 |
Post New Answer View All Answers
ow to bring suspect mode datbase online from scratch
Explain how to integrate the ssrs reports in application?
How are the unique and primary key constraints different?
What is checkpoint process in the sql server?
What is the sql profiler?
How to get the definition of a stored procedure back?
What does the on update no action do?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Detail about query optimizer?
What is the most common type of join?
How to deploy the Report?
How to generate create function script on an existing function?
How to view existing indexes on an given table using sp_help?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What is Service Broker in sql server 2012?