云数据库 GaussDB-ALTER SCHEMA:示例

时间:2023-11-01 16:22:02

示例

--创建模式ds。openGauss=# CREATE SCHEMA ds;--将当前模式ds更名为ds_new。openGauss=# ALTER SCHEMA ds RENAME TO ds_new;--创建用户jack。openGauss=# CREATE USER jack PASSWORD 'xxxxxxxxx';--将DS_NEW的所有者修改为jack。openGauss=# ALTER SCHEMA ds_new OWNER TO jack;--删除用户jack和模式ds_new。openGauss=# DROP SCHEMA ds_new;openGauss=# DROP USER jack;
support.huaweicloud.com/centralized-devg-v2-opengauss/devg_03_0510.html