DataGrip 2021.2 Help

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

                  1. Position the caret at the highlighted line and press Alt+Enter or click the Intention action icon.

                  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

                  Last modified: 16 July 2021