RETURNS Clause - Teradata Database - Teradata Vantage NewSQL Engine

SQL Data Manipulation Language

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
fbo1512081269404.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™
RETURNS database_name.table_name
Name of the table and its containing database, if different from the current database, into which the rows processed by the dynamic result row table function are to be inserted.
RETURNS column_name- data_type
Name and data type of one or more columns to be assigned to the row fields returned by a dynamic result row table function.
You cannot use the BLOB AS LOCATOR or CLOB AS LOCATOR forms to specify columns that have a BLOB or CLOB data type.
For more information, see “CREATE FUNCTION (Table Form)” in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 .