Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

Conventional Identifiers

Unless they are delimited identifiers (refer to Delimited Identifiers), FairCom DB SQL identifiers must:

  • Begin with an uppercase or lowercase letter
  • Contain only letters, digits, or the underscore character ( _ )
  • Not be reserved words

Except for delimited identifiers, FairCom DB SQL does not distinguish between uppercase and lowercase letters in identifiers. By default, all database object names are converted to lowercase. However, SQL statements can refer to the names in mixed case. Thus, conventional names for database objects, such as tables, columns, indexes, and so forth, are case-insensitive.

The following examples show some of the characteristics of conventional identifiers:

-- Names are case-insensitive:

CREATE TABLE TeSt (CoLuMn1 CHAR);

INSERT INTO TEST (COLUMN1) VALUES('1');

1 record inserted.

SELECT * FROM TEST;

COL

---

1

1 record selected

TABLE TEST;

COLNAME NULL ? TYPE LENGTH

------- ------ ---- ------

column1

-- Cannot use reserved words:

CREATE TABLE TABLE (COL1 CHAR);

CREATE TABLE TABLE (COL1 CHAR);

*

error(-20003): Syntax error

TOCIndex