TABLE Option | SQL SELECT Statements | Teradata Vantage - 17.05 - TABLE Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

Use this option in the FROM clause to invoke a user-defined table function that returns row results as a derived table.

The TABLE option can only be specified once in a FROM clause.

The TABLE option cannot be specified in a FROM clause that also specifies the JOIN option.

For information about creating table functions, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics , B035-1184 .