ALTER DATABASE

修改数据库名称，或为数据库设置默认存储选项。

语法

-- Rename a database
ALTER DATABASE [ IF EXISTS ] <name> RENAME TO <new_db_name>

-- Set default storage options
ALTER DATABASE [ IF EXISTS ] <name> SET OPTIONS (
    DEFAULT_STORAGE_CONNECTION = '<connection_name>'
  | DEFAULT_STORAGE_PATH = '<path>'
)

参数

示例

重命名数据库

CREATE DATABASE LAKE;

SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| LAKE           |
| information_schema |
| default            |
| system             |
+--------------------+

ALTER DATABASE `LAKE` RENAME TO `NEW_LAKE`;

SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| NEW_LAKE       |
| default            |
| system             |
+--------------------+

设置默认存储选项

ALTER DATABASE analytics SET OPTIONS (
    DEFAULT_STORAGE_CONNECTION = 'my_s3',
    DEFAULT_STORAGE_PATH = 's3://mybucket/analytics_v2/'
);

标签操作

为数据库分配或移除标签。必须先使用 CREATE TAG 创建标签。完整详情请参见 SET TAG / UNSET TAG。

语法

ALTER DATABASE [ IF EXISTS ] <name> SET TAG <tag_name> = '<value>' [, <tag_name> = '<value>' ...]

ALTER DATABASE [ IF EXISTS ] <name> UNSET TAG <tag_name> [, <tag_name> ...]

示例

ALTER DATABASE mydb SET TAG env = 'prod', owner = 'team_a';
ALTER DATABASE mydb UNSET TAG env, owner;