primary key

[Former Member]

how many primary keys we can set in a table?

[RichHeilman]

one, you can have many secondary indexes.

Regards,

RIch Heilman

[Former Member]

Hi,

I believe the maximum length of the primary key should be 256.

Thanks,

Naren

[Former Member]

Hi,

There are two restrictions on the key fields while creating a table.

1) The maximum number of keys in a table is 16.

2) The maximum length of the key fields is 120.

Regards,

Ferry Lianto

[Former Member]

as many as u want....it depends on ur requirement...if it is 1 then is a primary key and if it is more it is called a composite primary key....

[Former Member]

Hi Sunil,

Primary key is one only it's created when you create a table with KEY Fields.

Hope this answer is with more clarity. Please reward point to useful ans.

Cheers,

Darshan.

[Former Member]

Hi Sunil,

A maximum of 16 key fields per table is permitted. The maximum length of the table key is 255.

If the key length is greater than 120, there are restrictions when transporting table entries. The key can only be specified up to a maximum of 120 places in a transport. If the key is larger than 120, table entries must be transported generically.

Regards

Sudheer