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


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


Syntax Syntax

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

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)