Identifier length

32 characters

Precision of numeric values

38 digits

Number of tables

unlimited

Internal length of a table row

8088 bytes

Length of a LONG column

2147483647 bytes

Number of columns per table (with KEY)

1024

Number of columns per table (without KEY)

1023

Number of primary key columns per table

512

Sum of internal lengths of all key columns

1024 bytes

Number of indexes per table

255

Number of columns in an index

16

Sum of internal lengths of all columns belonging to an index

1024 bytes

Number of referential CONSTRAINT definitions (foreign key dependencies) per table

unlimited

Number of columns in a referential CONSTRAINT definition

16

Number of triggers per table

3

Number of rows per table

unlimited

Number of result columns in a SELECT instruction

1023

Number of join tables in a SELECT statement

64

Number of join conditions in a WHERE clause of a SELECT statement

128

Number of correlated columns in an SQL statement

64

Number of correlated columns in an SQL statement

16

Number of the columns in an ORDER or GROUP clause

128

Length of the columns in an ORDER or GROUP clause

1020 bytes

Number of parameters in an SQL statement

2000

Length of an SQL statement (Configuration parameter _PACKET_SIZE less administration overhead)

at least 16000 bytes