Developing Portable Applications > Developing Portable Applications > Application Considerations > Implementation Differences > Table and Column ID Length
Was this helpful?
Table and Column ID Length
The maximum lengths for DBMS table and column identifiers are shown in the following table:
DBMS
Length
Ingres 10.0
256
Ingres 9.3
32
Ingres 6.4
24
Microsoft SQL
128
Oracle
30
OpenSQL
256
Note:  For optimal portability, limit names to a maximum of 18 characters, because maximum lengths for EDBC-supported databases have not been increased.
Applications should be modified to take these limitations into account.
For more information, see Object Name Length.
Last modified date: 02/16/2024