# SQL identifiers

An identifier is the representation within the language of items created by the user, as opposed to language keywords or commands.

Some identifiers stand for dictionary objects, which are the objects you create -- such as tables, views, indexes, columns, and constraints -- that are stored in a database. They are called dictionary objects because Derby stores information about them in the system tables, sometimes known as a data dictionary. SQL also defines ways to alias these objects within certain statements.

Each kind of identifier must conform to a different set of rules. Identifiers representing dictionary objects must conform to SQL identifier rules and are thus called SQLIdentifiers.

- Rules for SQL identifiers
  Ordinary identifiers are identifiers not surrounded by double quotation marks. Delimited identifiers are identifiers surrounded by double quotation marks.
- SQLIdentifier
- aggregateName
- authorizationIdentifier
- columnName
- constraintName
- correlationName
- cursorName
- functionName
- indexName
- newTableName
- procedureName
- roleName
- schemaName
- sequenceName
- simpleColumnName
- synonymName
- tableName
- triggerName
- typeName
- viewName

Parent topic: SQL language reference
Related concepts
Statements
Built-in system functions
Built-in system procedures
Data types
Related reference
Capitalization and special characters
SQL clauses
SQL expressions
JOIN operations
SQL queries
Built-in functions
SYSCS_DIAG diagnostic tables and functions