On this page
Warning:
As of April 12, 2019, CockroachDB v1.1 is no longer supported. For more details, refer to the Release Support Policy.
The RENAME DATABASE
statement changes the name of a database.
Note:
It is not possible to rename a database referenced by a view. For more details, see View Dependencies.Synopsis
Required Privileges
Only the root
user can rename databases.
Parameters
Parameter | Description |
---|---|
name |
The first instance of name is the current name of the database. The second instance is the new name for the database. The new name must be unique and follow these identifier rules. |
Examples
Rename a Database
> SHOW DATABASES;
+----------+
| Database |
+----------+
| db1 |
| db2 |
| system |
+----------+
> ALTER DATABASE db1 RENAME TO db3;
RENAME DATABASE
> SHOW DATABASES;
+----------+
| Database |
+----------+
| db2 |
| db3 |
| system |
+----------+
Rename Fails (New Name Already In Use)
> SHOW DATABASES;
+----------+
| Database |
+----------+
| db2 |
| db3 |
| system |
+----------+
> ALTER DATABASE db2 RENAME TO db3;
pq: the new database name "db3" already exists