Identifier (SQL)

Introduction

In SQL an Identifier is used to declare:

The name of a column in a Select List.
The alias name of a column in a Select List.
A Column Reference in an expression.
The name of a table in a Table Reference List

A Regular Identifier is used to declare the name of a Host Parameter.

Syntax

identifier ::=
regular-identifier
| delimited-identifier
| unicode-delimited-identifier

regular-identifier ::=
letter [{letter | number | '_' }]

delimited-identifier ::=
'"' delimited-identifier-body '"'

delimited-identifier-body ::=
delimited-identifier-part [{delimited-identifier-part}]

delimited-identifier-part ::=
non-double-quote-character | double-quote-symbol

unicode-delimited-identifier ::=
'U' '&' '"' unicode-delimited-identifier-body '"'

unicode-delimited-identifier-body ::=
unicode-delimited-identifier-part [{unicode-delimited-identifier-part}]

unicode-delimited-identifier-part ::=
non-double-quote-character | double-quote-symbol

Remarks

An identifier declares the name of a column, table, schema or catalog.

Examples

A regular identifier:
```
information_schema
```
A delimited identifier:
```
"Spaces Allowed"
```
A unicode delimited identifier:
```
U&"information_schema"
```

Further Information

Fernhill SCADA SQL

To learn more about the SQL features in Fernhill SCADA.

Column Reference (SQL)

To see how identifiers are used to reference columns.

Glossary

For the meaning of terms used in Fernhill SCADA.