Show TOC

Column Specification (column_spec)Locate this document in the navigation structure

Use

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

Structure
				
<column_spec>::=
  <column_name>
| <table_name>.<column_name>
| <reference_name>.<column_name>
| <result_table_name>.<column_name>
				
			

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)