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

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

---

What is cte (common table expression)?

0 Answers  

---

How do you check sql server is up and running?

0 Answers  

---

What is left outer join in sql server joins?

0 Answers  

---

When do u use clustered index and non-clustered index?

3 Answers   IBM,

---

Difference between report and query parameter.

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

0 Answers  

---

What is Replication?

0 Answers  

---

What is a transactions?

0 Answers  

---

Will count(column) include columns with null values in its count?

0 Answers  

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

---