Brahma

[Former Member]

What is the maximum Number of primary keys we can hav in a database table ?

[Former Member]

What is the maximum Number of primary keys we can hav in a database table ?

[Former Member]

16 primary keys

[Former Member]

Hi,

No limitations on primary key fields. It will be based on field combination in table.

Hope this Info will help you .

Rewards points if Useful.

With Regards,

K K V

[seshatalpasai_madala]

Hi,

There can be only one PRIMARY KEY per table.

You can have upto 16 fields in your primary key.

Regards,

Sesh

[Former Member]

Hi Brahmaji,

In relational database design, a unique key or primary key is a candidate key to uniquely identify each row in a table. A unique key or primary key comprises a single column or set of columns. No two distinct rows in a table can have the same value (or combination of values) in those columns. Depending on its design, a table may have arbitrarily many unique keys but at most one primary key.