Regular Identifiers

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.

               <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'.
            

Example

               SELECT col FROM dbtab WHERE DBTAB.COL = 'abc'
            

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