Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Database Conversion overview.

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