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
What is explicit mode in sql server?
What is use of @@ spid in sql server?
How many partitions a clustered index has by default in sql server 2012?
Difference between Logical Page and Physical Page in SSRS.
Is ssrs support other database except ms sql server?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Why SQL Agent is used?
What is intellisense?
How can we solve concurrency problems?
Explain sql server service broker?
What is sql server management studio? : sql server management studio
How to create a view using data from another view?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain the creation and execution of a user-defined function in the sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
