Commands
ALTER CONNECTION
The ALTER CONNECTION
command modifies the definition of a connection. To use this command, you must own the connection.
Syntax
alteroption
depends on the operation you want to perform on the connection. For all supported clauses, see the sections below.
Clause
SET SCHEMA
Parameter or clause | Description |
---|---|
SET SCHEMA | This clause changes the schema of the connection. To change a connection’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?