Identifier (SQL)

Help Contents

Introduction

An Identifier is used to specify:

A Regular Identifier is used to specify 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 specifies the name of a column, table, schema or catalog.

Examples

  1. A regular identifier:
    information_schema
  2. A delimited identifier:
    "Spaces Allowed"
  3. A unicode delimited identifier:
    U&"information_schema"

Further Information

Fernhill SCADA Structured Query Language (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.