SQL statement reference for queries referencing table UDFs and TPFs.
ALTER PROCEDURE Statement
Replaces an existing procedure with a modified version. Include the entire modified procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.
CREATE PROCEDURE Statement (Table UDF)
Creates an interface to an external table user-defined function (table UDF). Users must be specifically licensed to use table UDFs.
DEFAULT_TABLE_UDF_ROW_COUNT Option
Enables you to override the default estimate of the number of rows to return from a table UDF (either a C, C++, or Java table UDF).
TABLE_UDF_ROW_BLOCK_SIZE_KB Option
Controls the size, in kilobytes, for server-allocated row blocks. Row blocks are used by Table UDFs and TPFs.
FROM Clause
Specifies the database tables or views involved in a SELECT statement.