Rules for SQL92 identifiers
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.
dictionary objects must conform to SQL-92 identifier rules and are thus called
identifiers are identifiers surrounded by double quotation marks.
characters (_), and digits. The permitted letters and digits include all Unicode letters and
digits, but Derby does not attempt to ensure that the characters in identifiers are valid in
the database's locale.
The enclosing double quotation marks are not part of the identifier; they serve only to
mark its beginning and end. Spaces at the end of a delimited identifier are insignificant
(truncated). Derby translates two consecutive double quotation marks within a delimited
identifier as one double quotation mark-that is, the "translated" double quotation mark
becomes a character in the delimited identifier.
name of the dictionary object being represented).
within the table "A").
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.
-- 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
dictionary objects.