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 to create a testing table with test data in ms sql server?

0 Answers  

---

What are the different subsets of sql?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What are date and time data types in ms sql server?

0 Answers  

---

What are the different sql server versions?

0 Answers  

---

What is transaction server distributed transaction?

0 Answers  

---

What is ms sql server index?

0 Answers  

---

How is sql server used?

0 Answers  

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---