Compiles and installs an external UDF and creates or replaces the SQL function definition used to invoke that UDF.
- CREATE FUNCTION and REPLACE FUNCTION Syntax (External Form)
- CREATE FUNCTION and REPLACE FUNCTION Syntax Elements (External Form)
- CREATE FUNCTION and REPLACE FUNCTION Usage Notes (External Form)
- CREATE FUNCTION and REPLACE FUNCTION Examples (External Form)
- CREATE FUNCTION and REPLACE FUNCTION Related Information (External Form)
ANSI Compliance
CREATE FUNCTION is ANSI SQL:2011-compliant with extensions.
REPLACE FUNCTION is a Teradata extension to the ANSI SQL:2011 standard.
Required Privileges
- You must have explicit DROP FUNCTION privileges on the function or on the database in which the function is contained to perform the REPLACE FUNCTION statement on an existing function. You do not need the CREATE FUNCTION privilege to replace a function.
- You must have explicit CREATE FUNCTION privileges on the database in which the function is to be contained to perform the REPLACE FUNCTION statement to create a new function.
- If you are not the creator of a function, you must have the EXECUTE FUNCTION privilege on any UDF that you run from the SYSLIB database.
The creator of a function is granted EXECUTE FUNCTION on that UDF automatically.
If the function is to be used to enforce the security policy for a table row, but the purpose of the function is not to delete, insert, select, or update table rows, you must have the appropriate OVERRIDE DELETE CONSTRAINT, OVERRIDE INSERT CONSTRAINT, OVERRIDE SELECT CONSTRAINT, or OVERRIDE UPDATE CONSTRAINT privilege to run it. The request that invokes the function must also include the values to be assigned to the constraint columns of the target table rows.
Privileges Granted Automatically
- DROP FUNCTION
- EXECUTE FUNCTION