This topic provides a list of the maximum sizes for various attributes of the OpenEdge® SQL database environment, and for elements of SQL queries addressed to this environment.

The following table provides a list of the maximum sizes for various attributes of the OpenEdge SQL database environment, and for elements of SQL queries addressed to this environment.

Table 1. OpenEdge SQL system limits
Attribute Value
Maximum number of open cursors 50
Maximum number of procedure arguments in an SQL CALL statement 100
Maximum length of an SQL statement 131000
Maximum length of a column in a table 31983
Maximum length of default value specification 250
Maximum length of a connect string 100
Maximum length for a table name 32
Maximum length for an area name 32
Maximum length for a username in a connect string 32
Maximum length of an error message 256
Maximum number of columns in a table 5000
Maximum number of bytes that can be inserted in a large key entry 1980
Maximum number of bytes that can be inserted in a small key entry 193
Maximum length of a CHECK constraint clause 240
Maximum number of nesting levels in an SQL statement 25
Maximum number of table references in an SQL statement: other platforms 250
Maximum size of input parameters for an SQL statement 512
Maximum number of outer references in an SQL statement 50
Maximum nesting level for view references 25
Maximum number of check constraints in a table 1000 total constraints per table
Maximum number of foreign constraints in a table 1000 total constraints per table
Maximum LOB length 1 GB
Maximum number of databases that can be connected 16 (1 primary and 15 auxiliary)