Background documentationColumn Specification (column_spec) Locate this document in the navigation structure

 

A column specification (column_spec) specifies a column in a table.

Structure

Syntax Syntax

  1. <column_spec> ::=
  <column_name>
| <table_name>.<column_name>
| <reference_name>.<column_name>
| <result_table_name>.<column_name>
End of the code.
Explanation

For all names consisting of several identifiers that are separated by a period ("."), any number of blanks can be specified before and after the period.

More Information

A column specification is used in the following SQL syntax elements:

Expression (expression)

Boolean Predicate (bool_predicate)

DEFAULT Predicate (default_predicate)