Quotable Tip for c-treeSQL Reserved Words

Many times a c-treeSQL application developer chooses a logically apt column name, however, this name just happens to collide with a c-treeSQL reserved word. What should you do?

Quote them! Surrounding any c-treeSQL identifier in double quotes ensures they are properly interpreted as a table name, column name, or other identifier.

Example:

CREATE TABLE "version" ("character" VARCHAR(10), "hour" VARCHAR(10));

INSERT INTO "version" VALUES ("Cinderella", "midnight");

SELECT "character", "hour" FROM "version";

To ensure your application is always prepared for future versions of c-treeSQL it could be considered prudent to always quote identifiers, thus avoiding issues with future reserved words.

Here's a complete list of Version 8.14 c-treeSQL Reserved Words.