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.
CREATE FUNCTION Statement
Creates a user-defined function in the database. A function can be created for another user by specifying an owner name. Subject to permissions, a user-defined function can be used in exactly the same way as other non-aggregate functions.
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).