topic Brahma in Application Development and Automation Discussions

Brahma

Former Member — Tue, 18 Sep 2007 05:51:11 GMT

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

Re: Brahma

Former Member — Tue, 18 Sep 2007 05:56:06 GMT

16 primary keys

Re: Brahma

Former Member — Tue, 18 Sep 2007 05:58:38 GMT

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

Re: Brahma

seshatalpasai_madala — Tue, 18 Sep 2007 06:01:04 GMT

Hi,

There can be only one PRIMARY KEY per table.

You can have upto 16 fields in your primary key.

Regards,

Sesh

Re: Brahma

Former Member — Tue, 18 Sep 2007 06:18:15 GMT

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.