topic primary key in Application Development and Automation Discussions

primary key

Former Member — Sat, 05 May 2007 15:16:40 GMT

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

give in a table?

Former Member — Sat, 05 May 2007 15:21:01 GMT

hi,

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

Regards,

Santosh

h_senden2 — Sat, 05 May 2007 15:28:23 GMT

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