What is the maximum number of fields you can have in a table?

[JamesBowen]

What is the maximum number of fields you can have in a table? Current I'm working on a project where I currently have 87 fields.

I know this is a lot of fields and I will do something about it but I was just curious.

Detail: OE 10.2A

 

[jongpau]

Hi Neighbour,

According to the documentation....

You cannot split a table or an index across storage areas. Each table and each index can be assigned to only one storage area. Therefore, the size of a table or index is limited to the size of the storage area in which it resides. The following limits exist:

- The maximum number of tables supported is 32,767, regardless of block size.
- Tables have a maximum number of fields: SQL supports 500, ABL supports 1000.
- The maximum number of indexes supported is 32,767, regardless of block size.
- Index entries have a maximum of 16 fields per index.

Looks like you have a fair way to go before you reach the limits

 

[JamesBowen]

Thanks. Good to know.