15.00 - Terminology - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Terminology

 

Term

Definition

Access column

A column name that would be specified in the WHERE clause of a query.

In the following WHERE clause, column_name is the name of the access column:

     WHERE column_name = ‘xyx’

Join column

A column name that would be specified in the ON clause of a join query.

In the following ON clause, table_1.column_name and table_2.column_name are the names of join columns:

     ON table_1.column_name = table_2.column_name