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® Enterprise Edition 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`

Did you find this helpful?

Yes No