ALTER DEFAULT SCHEMA¶
ALTER DEFAULT SCHEMA
can be used to change a role’s default schema.
The default schema in SQream DB is public
.
See also: CREATE SCHEMA, DROP SCHEMA.
Permissions¶
No special permissions are required
Syntax¶
alter_default_schema_statement ::=
ALTER DEFAULT SCHEMA FOR role_name TO schema_name
;
role_name ::= identifier
schema_name ::= identifier
Parameters¶
Parameter |
Description |
---|---|
|
The name of the role the change will apply to. |
|
The new default schema name. |