Background documentationRestrictions for SQL Statements Locate this document in the navigation structure

 

Restrictions for SQL Statements

Maximum length of an SQL statement

16 KB (Default setting 64 KB), defined by a support database parameter

Length of an identifier

32 characters

Numeric precision

38 places

Number of tables

Unlimited

Number of columns in each table (with KEY)

1024

Number of columns in each table (without KEY)

1023

Number of primary key columns in each table

512 (Restricted by Total of internal lengths of all key columns)

Number of columns in an index

16

Number of foreign key columns per table

16 (Restricted by Total of internal lengths of all foreign key columns)

Number of columns in an ORDER or GROUP clause

128

Number of columns in an SELECT statement

1023

Number of columns in an INSERT statement

1024

Number of columns in a results table

1023

Number of join tables in a SELECT statement

254

Number of triggers in each basis table

3

Number of indexes for each table

255

Number of JOIN predicates in a search condition

Unlimited

Number of referential CONSTRAINT definitions (foreign key dependencies) for each table

Unlimited

Number of references in each table

Unlimited

Number of rows in each table

Limited by the size of a database

Internal length of a table row

32767 Bytes

Total of internal lengths of all key columns

1024 Bytes

Total of internal lengths of all foreign key columns

1024 Bytes

Total of internal lengths of all columns belonging to an index

1024 Bytes

Internal length of a LOB column

2 GB

Length of the columns in an ORDER or GROUP clause

4016 Bytes

Nested trigger levels

Unlimited

Nested subqueries

127

Number of correlated columns in an SQL statement

64

Number of correlated tables in an SQL statement

16

Number of parameters in an SQL statement

10000