Developing Portable Applications : 3. Application Considerations : Implementation Differences : Table and Column ID Length
 
Share this page                  
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
DB2 UDB
128
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.