ALTER SCHEMA
Function
ALTER SCHEMA changes the attributes of a schema.
Precautions
Only the owner of a schema, a user granted with the ALTER permission for the schema, or a system administrator has the permission to run the ALTER SCHEMA statement.
Only the schema owner or the system administrator can change the owner of a schema.
Syntax
- Rename a schema.
1 2
ALTER SCHEMA schema_name RENAME TO new_name;
- Changes the owner of a schema.
1 2
ALTER SCHEMA schema_name OWNER TO new_owner;
- Changes the storage space limit of the permanent table in the schema.
1 2
ALTER SCHEMA schema_name WITH PERM SPACE 'space_limit';
Parameter Description
- schema_name
Indicates the name of the current schema.
Value range: An existing schema name.
- RENAME TO new_name
Renames a schema.
new_name: new name of the schema
Value range: A string. It must comply with the naming convention.
- OWNER TO new_owner
Changes the owner of a schema. To do this as a non-administrator, you must be a direct or indirect member of the new owning role, and that role must have CREATE permission in the database.
new_owner: new owner of a schema
Value range: An existing user name/role.
- WITH PERM SPACE
Changes the storage upper limit of the permanent table in the schema. If a non-administrator user wants to change the storage upper limit, the user must be a direct or indirect member of all new roles, and the member must have the CREATE permission on the database.
space_limit: storage upper limit of the permanent table in the new schema.
Value range: A string consists of an integer and unit. The unit can be K/M/G/T/P currently. The unit of parsed value is K and cannot exceed the range that can be expressed in 64 bits, which is 1 KB to 9007199254740991 KB.
Examples
Create an example schema schema_test and user user_a.
1 2 |
CREATE SCHEMA schema_test; CREATE USER user_a PASSWORD '{Password}'; |
Rename the schema_test schema as schema_test1.
1
|
ALTER SCHEMA schema_test RENAME TO schema_test1; |
Change the owner of schema_test1 to user_a.
1
|
ALTER SCHEMA schema_test1 OWNER TO user_a; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot