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

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

---

What is an expensive query?

0 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

1 Answers   Covansys,

---

What is index?

1 Answers   Cap Gemini,

---

What are the 7 disadvantages to a manual system?

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---