no of key fields in a database table

[Former Member]

hello experts,

can anyone tell me what is the maximum number of keys we can have in a database table.

thanks in advance

[ferry_lianto]

Hi,

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

1) The maximum number of keys in a table can be 16

2) The maximum length of the key fields can be 120.

Regards,

Ferry Lianto

[Former Member]

max no of key fieslds in a table is 16

1 is for primary

15 are secondary

[Former Member]

HI ,

U can have upto 16 primary keys however there is no limit for the secondry index .

Thanks .