Code Inspection: Excessively long identifiers

Reports identifiers that are considered too long. The length limitation is different for different databases.

Example (MySQL):

CREATE TABLE ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
(
   ooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo int
);

In MySQL, the identifier must not exceed 64 characters.

Consider the following limitations for different databases:

Sybase ASE:
253 for quoted names
255 for unquoted names

Db2 LUW:

18 for BUFFER POOL, INDEX EXTENSION, TABLESPACE, TRANSFORM, and TYPE MAPPING

128 for other objects

Db2 iSeries: 128

Db2 z/OS:

8 for DATABASE and TABLESPACE

30 for columns and cursors with WITH RETURN

128 for other objects

Derby: 128

Exasol: 128

HSQLDB: 128

MySQL:

256 for aliases in queries

32 for USER and ROLE

64 for other objects

MariaDB:

80 for USER

128 for ROLE

Other objects as in MySQL

Microsoft SQL Server: 128

Vertica: 128

SQL 92: 128

Snowflake: 255

Redshift: 127

PostgreSQL/Greenplum/Cockroach: 63

Oracle:

Long names are enabled (database.oracle.names.long is specified, Oracle version is earlier than 12.2 or is unknown):

30 for DISKGROUP, ROLLBACK SEGMENT, TABLESPACE, and PLUGGABLE DATABASE

8 for DATABASE

128 for other objects

Long names are disabled:

8 for DATABASE

128 for DATABASE LINK

30 for other objects

Suppress an inspection in the editor

Position the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 16 July 2021