Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

Maximum Length of Identifiers

Table 14 shows the information about the maximum length, in characters, of identifiers in databases.

TABLE 14. Maximum Length of Identifiers
Identifiers
 
Oracle
IBM DB2
Microsoft
SQL
Server
Sybase
MySQL
Pervasive.SQL
 
Unix, Windows
OS/390
AS/400
ASE
ASA
Table
30
128
18
128
128
30
128
64
20
Column
30
30
18
30
128
30
128
64
20
Primary
30
30
18
18
128
30
128
64
20
Foreign
30
30
18
18
128
30
128
64
20
Check
30
30
18
18
128
30
128
64
N/A
Unique
30
30
18
18
128
30
128
64
20
Index
30
18
18
128
128
30
128
N/A
20
View
30
128
18
128
128
30
128
N/A
20
Procedure
30
128
18
128
128
30
128
N/A
30
Function
30
18
18
128
128
30
128
N/A
N/A
Trigger
30
18
8
128
128
30
128
N/A
30


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.