RETURNS Clause
|
Syntax Element … |
Specifies … |
|
RETURNS database_name.table_ |
the 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 |
the 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 SQL Data Definition Language. |