Show TOC

Syntax documentationRegular Identifiers Locate this document in the navigation structure

Use

A regular identifier is a character sequence starting with a letter followed by a sequence of letters, digits or the underscore sign. Although it can be typed in mixed case, it will be interpreted in upper case. That is the regular identifiers Hugo, hugo, HUGO name all the same database object.

An SQL reserved keyword may not be used as regular identifier The table editor does not permit creating catalog objects with a name equal to a reserved keyword.

Syntax Syntax

  1. <regular identifier> ::= <letter> ( <letter> | <digit> | '_' )*.
<letter>s are the 52 Latin letters 'a' to 'z' and 'A' to 'Z'<digit> is a digit from '0' to '9'.
End of the code.
Example

Syntax Syntax

  1. SELECT col FROM dbtab WHERE DBTAB.COL = 'abc'
End of the code.

Regular Identifiers. In this example, col and COL denominate the same column, dbtab and DBTAB denominate the same table.