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
How to create a trigger for insert only?
What is recompile sql server?
What is row_number () and partition by in sql server?
Explain the truncate command?
Do you know what is similarity and difference between truncate and delete in sql?
What is the use of builtinadministrators group in sql server? : sql server security
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is a covering index?
Explain the concept of recursive stored procedure.
What is merge?
How can change procedure in sql server?
What is the difference between count and distinct count?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
Explain Geometry datatype in sql server 2008 with example
