Examples of Delimited Identifiers

The next example shows how to create a table with a case-sensitive name:

CREATE TABLE "Proper_Ranger" (...);

The following example creates a table whose name includes a white-space character. If the table name were not enclosed by double ( " ) quotation marks, and if DELIMIDENT were not set, you could not use a blank space in the identifier.

CREATE TABLE "My Customers" (...);

The next example creates a table that has a keyword as the table name:

CREATE TABLE "TABLE" (...);

The following example for HCL OneDB™ shows how to delete all the rows from a table that is named FROM when you omit the keyword FROM in the DELETE statement:

DELETE “FROM”;