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 are different types of join?
what information is maintained within the msdb database? : Sql server administration
What is difference between rownum and rowid?
What is the cartesian product of the table?
What is TDS(Tabular Data Stream) Gateway?
Can we use having clause without group by?
If a stored procedure is taking a table data type, how it looks?
What are the differences between DDL, DML and DCL in SQL?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is 1nf 2nf?
What are the 7 disadvantages to a manual system?
What are the restrictions that views have to follow? : SQL Server Architecture
Difference between Sql server reporting services and Crystal reports?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
Tell me what are the essential components of sql server service broker?
