Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Renaming Database Names

By: FYIcenter.com

(Continued from previous topic...)

How to rename databases?

If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name 
   MODIFY NAME = new_database_name

The tutorial example below shows you how change the database name from "FyiCenterData" to "FyiCenterComData":

ALTER DATABASE FyiCenterData 
   MODIFY NAME = FyiCenterComData
GO
The database name 'FyiCenterComData' has been set.

(Continued on next topic...)

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?