Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages


Sometimes you need to change the name of your databasebecause of the original name was not more relevant to the data. Or, you just want to give a temporary name to that data.

SQL RENAME DATABASE statement is used to change the name of a database.

Let’s see how to rename MySql and SQL Server databases.

Rename MySQL database

To rename the mysql database, you need to follow the following syntax:

  1. RENAME DATABASE old_db_name TO new_db_name;

Rename SQL server database using T-SQL

This command is useful for SQL server 2005, 2008, 2008R2 and 2012.

  1. ALTER DATABASE old_name MODIFY NAME = new_name

If you are using SQL server 2000, you can also use this command to rename the database. But, Microsoft phased out it.

  1. EXEC sp_renamedb ‘old_name’ , ‘new_name’