Answer / koteshwar rao .palleboina

when foreign key constraint is created on a column
referential integrity is achieved .
when foreign key constraint is created on a column,that
column reference other column in the different table or
even in the same table but the reference column must be
primary key or unique key.
when a new value is added in a column referenced with
foreign key ,then the foreign key relation checks whether
the new value matches with the reference column or not.
If value matches then they are allowed into the table

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

How much is a sql server license?

0 Answers  

---

What are the types of sql server?

0 Answers  

---

What is a full text index?

0 Answers  

---

How can you find out how many rows returned in a cursor?

0 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

What do mean by xml datatype?

0 Answers  

---

What is the use of placing primary key and foreign key constrains on columns.

4 Answers   Value Labs,

---

what is the difference between openrowset and openquery?

0 Answers  

---

Describe in brief authentication modes in sql server.

0 Answers  

---

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

---