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

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
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 .