Object
|
Maximum sizes / numbers
|
|
|
Multi-User Edition
|
Single-User Edition
|
Bytes per string field
|
64,000 (also limited by page size)
|
64,000 (also limited by page size)
|
Bytes per BLOB field
|
2GB
|
2GB
|
Bytes per index
|
64,000 (also limited by page size)
|
64,000 (also limited by page size)
|
Bytes per row
|
65,400 (also limited by page size)
|
65,400 (also limited by page size)
|
Columns per index
|
10,000
|
10,000
|
Columns per table
|
65,000
|
65,000
|
UNIQUE indexes or constraints per table
|
30,000
|
30,000
|
Database size
|
32 TB (also limited by file system and OS)
|
32 TB (also limited by file system and OS)
|
Identifier length (in characters)
|
255
|
255
|
Locks per connection
|
2,147,483,647
|
N/A
|
Rows per table
|
2,147,483,647
|
2,147,483,647
|
Tables per database
|
2,147,483,647
|
2,147,483,647
|
Bytes per page
|
65,536
|
65,536
|
Pages per database file
|
2,147,483,647
|
2,147,483,647
|
Connections per database
|
Maximum value of configured connections before creating database file (up to 2,147,483,647)
|
1
|
Records in transaction
|
2,147,483,647 (also limited by available RAM)
|
2,147,483,647 (also limited by available RAM)
|
In-memory table size
|
2,147,483,647 (also limited by available RAM)
|
2,147,483,647 (also limited by available RAM)
|
|
