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 the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

what is normalization? : Sql server database administration

0 Answers  

---

What is the purpose of forms?

0 Answers  

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

---

Explain index in sql server?

0 Answers  

---

---

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

Can two tables share a primary key?

0 Answers  

---

How to enable/disable indexes?

0 Answers  

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---

what is an index? : Sql server database administration

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---