Limitations on identifier length

The following table lists limitations on identifier lengths in Derby.

Table 1. Identifier length limitations
Identifier Maximum Number of Characters Allowed
Constraint name 128
Correlation name 128
Cursor name 128
Data source column name 128
Data source index name 128
Data source name 128
Savepoint name 128
Schema name 128
Unqualified column name 128
Unqualified function name 128
Unqualified index name 128
Unqualified procedure name 128
Parameter name 128
Unqualified trigger name 128
Unqualified table name, view name, stored procedure name 128
Related reference
Limitations for database values
DATE, TIME, and TIMESTAMP limitations
Numeric limitations
String limitations
XML limitations