15.10 - Derived Tables - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

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 SQL Data Manipulation Language, B035-1146 for complete documentation of derived tables.