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

Explain sql delete command?

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

What is the maximum size of column in sql server?

0 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

What do you mean by acid?

0 Answers  

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

What is analysis service repository?

0 Answers  

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

Explain system rowset functions?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

What is indexed views? plz explain with example?

2 Answers  

---