SQL Reference Guide

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 names are converted to lowercase, however, statements can refer to the names in mixed case. 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