Identifier (SQL)

Help Contents

Introduction

In SQL 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 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.