Identifier (SQL)

Help Contents

Introduction

An Identifier is used to declare:

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

  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.