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

what's the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

Is foreign key unique?

0 Answers  

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

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

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

What is Trigger?

3 Answers   Misys,

---

Explain about SQLOS?

0 Answers  

---

how can a database be repaired? : Sql server administration

0 Answers  

---

What is difference between line feed ( ) and carriage return ( )?

0 Answers  

---

What is the purpose of sql profiler in sql server?

0 Answers  

---