Identifiers

The database object name is known as its identifier. Servers, databases, and database objects such as tables, views, columns, indexes, triggers, procedures, constraints, rules, and so on can have identifiers. An object identifier is created when the object is defined. The identifier is then used to reference the object.

Note: Column names, table names and the other identifiers are internally translated to upper-case by the Compiler unless they’re enclosed between double quotes. In addition, the Compiler translates double quotes to single quotes unless the -csqq option is used.

The following statement, for example:

SELECT column1, column2 FROM table1 WHERE column1 = "x"

becomes:

SELECT COLUMN1, COLUMN2 FROM TABLE1 WHERE COLUMN1 = 'x'

The following statement, instead, is left unaltered, assuming that the program is compiled with -csqq:

SELECT "column1", "column2" FROM "table1" WHERE "column1" = "x"