Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between the application object and session object?
What is the use of sql profiler in sql server 2012?
What are the aggregate and scalar functions?
Explain user defined views?
Explain steps of normalization?
How to list all stored procedures in the current database using ms sql server?
What is update locks?
What is partition in sql server?
How to change a login name in ms sql server?
Tell me what is difference between clustered and non clustered index?
What are different types of raid levels?
Explain the first normal form(1nf)?
How to enable/disable indexes?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Is it possible for a stored procedure to call itself or recursive stored procedure?
