Answer / naresh

If you specify this option, later when you delete a row in
the parent table, the database server also deletes any rows
associated with that row (foreign keys) in a child table.
The principal advantage to the cascading-deletes feature is
that it allows you to reduce the quantity of SQL statements
you need to perform delete actions.

Answer / kunal sain

to drop the constraint from child table when dropping the
constraint from parent table.

Answer / 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
..........)

does physical index sort data

1 Answers  

---

What is a synonym for manipulation?

0 Answers  

---

can you any body tell me the difference between candidate key and primary key

4 Answers  

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers  

---

Define model database?

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

How do I find the sql server database version?

0 Answers  

---

List out some of the requirements to set up a sql server failover cluster?

0 Answers  

---

How to write a query with a full outer join in ms sql server?

0 Answers  

---

How to turn on the mssql api module in php?

0 Answers  

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---