Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# SQL Identifiers

TIBCO recommends administrators to define table and column names that follow the SQL identifier rules. For details, see "Column Names" in TIBCO ActiveSpaces® Administration.

In some situations, a data grid might contain non-standard table or column names. For example, a table copied from a legacy database might have columns with names that contain a space character or there might be a table or column name with a SQL keyword.

If you must refer to a non-standard identifier in a SQL statement, surround the identifier with any of the following escape characters:

Technique | Example
--- | ---
Double quotes | "column name"
Escaped double quotes | \"column name\"
Square brackets | [column name]
Back ticks (accent grave) | `column name`

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.