Ingres 11.0 | Regular and Delimited Identifiers

OpenSQL Reference Guide > OpenSQL Reference Guide > Overview of OpenSQL > OpenSQL Features > Regular and Delimited Identifiers

Was this helpful?

Regular and Delimited Identifiers

Identifiers in OpenSQL statements specify names for the following objects:

• User

• Column

• Correlation name

• Cursor

• Database procedure

• Database procedure parameter

• Index

• Prepared query

• Schema

• Table

• View

Specify these names using regular (unquoted) identifiers or delimited (double‑quoted) identifiers. For example:

• Table name in a select statement specified using a regular identifier:

select * from employees

• Table name in a select statement specified using a delimited identifier:

select * from "my table"

Delimited identifiers allow special characters to be embedded in object names. OpenSQL restricts the use of special characters in regular identifiers.

Last modified date: 01/30/2023