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
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Are all views updatable ?
Which are the third-party tools used in sql server and why would you use them?
Write a SQL query to make a column as unique?
How to add additional conditions in SQL?
What does it mean to invest in the index?
How to use subqueries in the from clause in ms sql server?
what is the difference between openrowset and openquery?
What is difference between clustered and non clustered index?
How to find the version of sql server? : sql server database administration
What is the difference between upgrade and migration in sql server?
Explain trigger and its types?
How can I track the changes or identify the latest insert-update-delete from a table?
What the class forname () does?
What is the difference between grant and with grant while giving permissions to the user?
