# SQL92Identifier

An SQL92Identifier is a dictionary object identifier that conforms to the rules of SQL-92. SQL-92 states that identifiers for dictionary objects are limited to 128 characters and are case-insensitive (unless delimited by double quotes), because they are automatically translated into uppercase by the system. You cannot use reserved words as identifiers for dictionary objects unless they are delimited. If you attempt to use a name longer than 128 characters, SQLException X0X11 is raised.

Derby defines keywords beyond those specified by the SQL-92 standard (see SQL reserved words).

#### Example

    -- the view name is stored in the
    -- system catalogs as ANIDENTIFIER
    CREATE VIEW AnIdentifier (RECEIVED) AS VALUES 1
    -- the view name is stored in the system
    -- catalogs with case intact
    CREATE VIEW "ACaseSensitiveIdentifier" (RECEIVED) AS VALUES 1

This section describes the rules for using SQL92Identifiers to represent the following dictionary objects.

- Qualifying dictionary objects

Parent topic: SQL identifiers
Related concepts
Rules for SQL92 identifiers
Related reference
column-Name
correlation-Name
new-table-Name
schemaName
Simple-column-Name
synonym-Name
table-Name
view-Name
index-Name
constraint-Name
cursor-Name
TriggerName
AuthorizationIdentifier