Modify Schema Properties

In this document, we will introduce how to modify the properties of a Schema to better meet your needs. We will explain in detail how to use the ALTER SCHEMA command to set and modify the PROPERTIES of a Schema, and provide some common usage examples.

Use the ALTER SCHEMA Command to Modify Schema Properties

To modify the properties of a Schema, you can use the following ALTER SCHEMA command:

ALTER SCHEMA scname SET PROPERTIES ('property_key'='property_value');

其中,scname 是您要修改的Schema名称,property_key 是要修改的属性键名,property_value 是对应的属性值。

Permission Requirements

To perform this operation, you need to have ALTER permission on the corresponding Schema.