Rules for identifiers

An SQL identifier is a string of letters, digits, and underscores that represents the name of a database object such as a table, column, index, or view.

A non-delimited SQL identifier must begin with a letter or underscore (_) symbol. Trailing characters in the identifier can be any combination of letters, digits, underscores, or dollar ($) signs. Delimited identifiers, however, can include any character in the code set of the database locale; see Delimited identifiers for more information.

Declaring identifiers that are SQL keywords can cause syntactic ambiguity or unexpected results. For additional information, see the Identifier segment in the HCL OneDB™ Guide to SQL: Syntax. See also Non-ASCII characters in identifiers and Valid characters in identifiers.

SQL identifiers can occupy up to 128 bytes on HCL OneDB. When you declare identifiers, make sure not to exceed the size limit for your database server. For example, the following statement creates a synonym name of eight multibyte characters:

CREATE SYNONYM A¹A²A³B¹B²C¹C²C³D¹D²E¹E²F¹F²G¹G²H¹H² FOR A¹A²B¹B²