SQL Rename Database Example

Let’s look at an example of how to rename a database in SQL.

First, we will create a database which will be renamed in the example:

Query:

CREATE DATABASE Test

Output:

Rename database in SQL Example

In this example, we will use the ALTER command with MODIFY NAME clause to rename the database.

Query:

ALTER DATABASE Test MODIFY NAME = Example

Output:

The database name is changed from Test to Example.

To rename a database in SQL use the ALTER DATABASE Statement with MODIFY NAME clause.

The ALTER command in SQL is used to make changes to a table or database. In this article, we will learn how to use the ALTER DATABASE statement with the MODIFY NAME clause to rename a database.