Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Identifier

Guidelines for Creating Identifiers

The guidelines for creating identifiers in the CSQL Interpreter are as follows:

  • An identifier must begin with a letter; it must not begin with a number or a symbol.
  • It is not case-sensitive.
  • CUBRID keywords are not allowed.
<identifier>

:: = <identifier_letter> [ { <other_identifier> } & ldots; ]

<identifier_letter>

:: = <upper_case_letter>
  | <lower_case_letter>

<other_identifier>

:: = <identifier_letter>
  | <digit>
  | _
  | #
  | %

<digit>

:: = 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

<upper_case_letter>

:: = A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P| Q | R | S | T | U | V | W | X | Y | Z

<lower_case_letter>

:: = a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p| q | r | s | t | u | v | w | x | y | z

Legal Identifiers
Beginning with a Letter

An identifier must begin with a letter. Except that, special characters are allowed.

The following are examples of legal identifiers.

a
a_b
ssn#
fg%
this_is_an_example_#%%#

Enclosing in Double Quotes or Square Brackets

If an identifier begins with a number or a symbol, the identifier must always be enclosed in double quotes or square brackets.

The following are examples of legal identifiers.

"select"
"@lowcost"
"low cost"
"abc""def"
[position]

Illegal Identifiers
Beginning with a Letter

If an identifier contains special characters such as an underline, it is not allowed.

_a
#ack
%nums

Beginning with a Number

An identifier which begins with a number is not allowed.

  • Example

2fer
88abs