topic Re: primary key in Application Development and Automation Discussions

primary key

Former Member — Tue, 16 Oct 2007 14:07:31 GMT

what are the maximum number of primary keys in a table ?

Both <b>Z</b> table and system table ?

Re: primary key

Former Member — Tue, 16 Oct 2007 14:12:47 GMT

We can have max 16 fields in Primary key for a Table.

This is the standard limit in most of the Databases.

ashish

Re: primary key

JozsefSzikszai — Tue, 16 Oct 2007 14:13:55 GMT

hi,

I am not sure if there is a maximum, however it is not advised to create more than something like 6-8, otherwise the database optimazier won't have any idea which one to choose and chances are that won't choose the best avaliable always.

Re: primary key

Former Member — Tue, 16 Oct 2007 14:14:12 GMT

In the sense of Oracle it should be 16.

if u increase more than 16 a big performence issue will raise

avoid more keys on the table and also the indexces...

Message was edited by:

Alvaro Tejada Galindo

Re: primary key

Former Member — Tue, 16 Oct 2007 14:15:23 GMT

Hi Nirmal,

Please go through the link below:

http://www.sapdb.org/7.4/sap_db_features.htm

Regards,

Amit

Re: primary key

Former Member — Tue, 16 Oct 2007 14:17:15 GMT

One primary key per table regardless of what type of table it is and regardless of what kind of database it is.

(You can have up to 16 fields in primary key.)