Answer / nevual

Primary keys are the unique identifiers for each row. They
must contain unique values and cannot be null. Due to their
importance in relational databases, Primary keys are the
most fundamental of all keys and constraints. A table can
have only one Primary key.
Foreign keys are both a method of ensuring data integrity
and a manifestation of the relationship between tables.

Answer / sudarsan

Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.

Answer / jai prakash chauhan

Primary keys are by default clustered index.

Answer / hr@tgksolutions.com

• Primary Key: A unique identifier for a table’s record (e.g., id in a table).
• Foreign Key: A column in a table that refers to the primary key of another table, establishing a relationship between tables.

What is the difference between a local and a global variable?

5 Answers  

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

What are the types of constraints?

1 Answers  

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

0 Answers  

---

What is the template in sql?

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

explain query execution plan

1 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

Questions on identity?

2 Answers   Infosys,

---