Skip to main content

RENAME DATABASE

Changes the name of a database.

Syntax​

ALTER DATABASE [ IF EXISTS ] <name> RENAME TO <new_db_name>

Examples​

CREATE DATABASE DATABEND;
SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| DATABEND           |
| information_schema |
| default            |
| system             |
+--------------------+
ALTER DATABASE `DATABEND` RENAME TO `NEW_DATABEND`;
SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| NEW_DATABEND       |
| default            |
| system             |
+--------------------+
Did this page help you?
Yes
No
Join our growing community
GitHub
🌟 7.3K Stars
Slack
Twitter
YouTube
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today