Answer Posted / subbu

Well the question is

Can a table have two primary keys?

Practically Yes.

But theoritically there will be only 1 primary key with
multiple foriegn keys which acts as a composite keys for the
original primary key. How ever in the create or alter
statements, we need to write primary key only once following
the column names either single or multiple.

By seeing the posts, I believe some of the guys has got
confused with the question & compared it with the SQL create
statements where in Primary Key is written only once & by
which concluding that a table cannot have multiple primary keys.

what are date and time data types? : Sql dba

1026

---

Does view contain data?

1084

---

Are views faster than queries?

1038

---

Which is faster joins or subqueries?

1034

---

what is the difference between truncate and drop statements? : Sql dba

1177

---

What is sql basics?

1079

---

How many tables can you join in sql?

1006

---

What is the difference between Union and Union all. Which is faster.

1438

---

What does the acronym acid stand for in database management?

1087

---

How we can update the view?

1096

---

What view means?

1024

---

Can I create table without primary key?

1042

---

How can I change database name in sql?

1156

---

how do you login to mysql using unix shell? : Sql dba

1124

---

discuss about myisam index statistics collection. : Sql dba

1000

---