Column References

Syntax

[schema.]table-name].column-name

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
table‑name

One of the following:

  • The name of a table
  • A table alias defined in the query's FROM clause
column‑name

A column name that is unique among all queried tables.

Restrictions

A a column reference cannot contain any spaces.