WATCOM SQL has been designed with as few limitations as possible. The following limitations do exist, but the memory and disk drive of the microcomputer are more limiting factors in most cases. DOS is limited to files that are 512 MB in size.

Database size

2 GB per file, 12 files per database

Number of tables per database

32,767

Number of tables referenced per transaction

no limit

Table size

2 GB -- must be in one file

Number of columns per table

999 (using 4K pages)

Number of rows per table

limited by table size

Row size

32 MB (using 4K pages)

Number of rows per database

Limited by file size

Field size

32,767

Number of indexes

32,767 per table

Maximum index entry size

No limit