The following limits apply to the c-tree ODBC Driver. Addition limits may be imposed by third-party ODBC applications.
Description
Value
Concurrently open tables:
16-bit multi-user non-server driver
All others
305
405
Number of rows:
2 billion
Number of columns in a query:
256
Size of a column:
2 gigabytes
Number of connections:
limited by memory
Table, index and column name length:
64 characters
Table qualifier:
68 characters
Maximum characters in a literal:
1000
Maximum columns in a CREATE TABLE statement:
Maximum ANDed predicates:
This example uses three ANDed predicates:
SELECT * FROM abc
WHERE c1 AND c2 AND c3 AND c4
300
Number of joined tables:
