Commands
ALTER FUNCTION
The ALTER FUNCTION
command modifies the definition of a function. To use this command, you must own the function.
Syntax
alteroption
depends on the operation you want to perform on the function. For all supported clauses, see the sections below.
Clause
SET SCHEMA
Parameter or clause | Description |
---|---|
SET SCHEMA | This clause changes the schema of the function. To change a function’s schema, you must also have CREATE privilege on the new schema. |
schema_name | Specify the schema to which you want to change. |
Was this page helpful?