Table Specifications

The following table gives the maximum size for various attributes of a table.

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Table size 1 gigabyte
Number of characters in a Text field 255
Number of characters in a Text field for double-byte character sets (DBCS), which require 2 bytes to store a single character 127
Number of characters in a Memo field 1 gigabyte
Size of a Long Binary (OLE Object) field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in an index 255
Number of characters in a validation message 255
Number of characters in a validation rule 2048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2000
Number of characters in a field property setting 255