Previous Topic: Summary of LimitsNext Topic: Data Type Limits


Logical Data Limits

Item

Maximum allowed

Tables in a dictionary

Unlimited

Views in a dictionary

32,767

Tables in an area

32,767

Indexes in an area

32,767

Bytes in a row

32,760

Columns in a table or view

1,024

CALC keys on a table

1

Indexes on a table

Unlimited

Columns in a CALC, index, foreign, or sort key

32

Length of a CALC, index, foreign, or sort key
Note: This includes length of the key columns, null indicators, and varchar length fields.

2000 bytes