Restrictions

Maximum values :

Number of tables unlimited

Length of an identifier 18 characters

Internal length of a table row 4047 characters

Columns per table (with KEY) 255 columns

Columns per table (without KEY) 254 columns

Number of key columns 127 columns

Precision of numeric values 18 digits

Sum of internal lengths of

all key columns 255 characters

Sum of internal lengths of all

columns belonging to an index 255 characters

Length of sort columns in SELECT 250 characters

Number of result columns 254 columns

Number of join tables in SELECT 16 tables

Number of join conditions in a

WHERE clause of a SELECT 64

Number of correlated columns in an

SQL statement 64

Number of correlated tables in an

SQL statement 16

Number of SERVERDBs in a distributed database 2048 SERVERDBs

Number of DEVSPACEs 64 DEVSPACEs

Length of an SQL statement 8240 characters

Number of parameters in an SQL statement 300 parameters