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 are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

What is sqlcmd?

0 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

Define indexes?

0 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

What security features are available for stored procedure?

0 Answers  

---

What is 1nf 2nf and 3nf?

0 Answers  

---

How to change a login name in ms sql server?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

what is raid? : Sql server database administration

0 Answers  

---