no of primary keys and max no of fields

[Former Member]

hi friends i want to know that how many primary key we can use in a table and how many total fields we can have in a table .

[Former Member]

you can create n number of primary as well as table fields.

[Former Member]

Hi,

Please go through the link below:

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

Thanks,

Reward If Helpful.

[Former Member]

Hi

You can use nay number of primary key fields

But the total key fields length is restricted to 255 byte length. you can't go beyond that...

[Former Member]

Hi Aditya,

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

A table may not have more than 249 fields. The sum of all field lengths is limited to 1962 (whereby fields with data type LRAW and LCHR are not counted).

for reference go through the link:

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb6e446011d189700000e8322d00/frameset.htm

[Former Member]

You can have as many key fields as you want, but you can not go over the 255 byte length for the total of all key fields. You will get a warning for over 120, as it says that there is limited functionality with a key over 120 in length.

Again, this is a total length of all key fields.