Size and number limitations

Chapter 47. SQL Anywhere Limitations
Size and number limitations

The following table lists the limitations on size and number of objects in SQL Anywhere database. The memory and disk drive of the microcomputer are more limiting factors in most cases.

Item Limitation

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 Limited by table size

Number of rows per database Limited by file size

Field size 2 GB

Number of indexes 32,767 per table

Maximum index entry size No limit

Item	Limitation
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	Limited by table size
Number of rows per database	Limited by file size
Field size	2 GB
Number of indexes	32,767 per table
Maximum index entry size	No limit

User-created indexes for the table can be stored separately from the table. The 2 GB limit for table size does not apply to Windows NT databases using the NTFS file system. For this platform only, the maximum table size is the largest file size allowed by the operating system.