primary key

[Former Member]

how many primary key we can give in a one table? and how many maxmium entries we can

give in a table?

[Former Member]

hi,

I think a table can have atmost <b>16</b> primary keys.

Regards,

Santosh

[h_senden2]

As the name says there's only 1 primary key.

Beside that you can define some secondary keys. I don't know if there's a maximum, but too many keys is bad for performance.

The number of entries in a tables depends on the number of fields, the definition of the fields and the memory of the the server.

regards,

Hans

please give reward points for useful answers