fields in a database table

[Former Member]

hai in a database table max how many fields we can create and what is max no of fields for a primary key

[Former Member]

<b>Constraints while creating a d/b table</b>

All the key fields of a table must be stored together at the beginning of the table. A non-key field may not occur between two key fields.

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

If the key length is greater than 120, there are restrictions when transporting table entries. The key can only be specified up to a maximum of 120 places in a transport. If the key is larger than 120, table entries must be transported generically.

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).

Fields of types LRAW or LCHR must be at the end of the table. Only one such field is allowed per table. There must also be a field of type INT2 directly in front of such a field. The actual length of the field can be entered there by the database interface

[Former Member]

also check this link

http://help.sap.com/saphelp_47x200/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm

[Former Member]

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

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

[Former Member]

Hi

Maximum No. Key fields = 16.

And the maximum length of the table key is 255...

Tne No of entries in a table is decied by the size of the table that you created..Goto Technical settings od the tble..There in the SIZE-CATEGORY you are assigning the size of the table..Press F1 there ,you can get all the details...

Hope This Will Helps You...

Reward All Helpfull Answers...........

[Former Member]

maximum no of entries in table can be upto 9999 if i am not wrong

when we check the table field POSITION in table DD03L, its length is 4

this defines the position of field in a table

so the maximum no can be 9999