Single Table - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

Single Table

This option enables the FROM clause of the seed statement to specify single tables.

A FROM clause can include a sequence of single table references, which creates an implicit inner join.

A FROM clause in a seed statement cannot specify the name of the WITH RECURSIVE query.

 

Syntax Element …

Specifies …

table_name

the name of a single table, derived table, table UDF, or view referred to in the FROM clause.

AS

an optional introduction to correlation_name.

correlation_name

an alias for the table referenced in the FROM clause.