16.20 - Derived Tables - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

The derived table allows the FROM list to specify a spool file composed of selected data from underlying tables. The derived table acts like a viewed table.

Derived tables are valid when coded as part of a seed query.

Derived tables are never valid when coded as part of a recursive query.

See Teradata Vantage™ SQL Data Manipulation Language , B035-1146 for complete documentation of derived tables.