SQL Rename Database

About rename database

Syntax of rename database

Example of rename database

About rename database

If you have created a database and want to change the name of the database then you can rename it but to do this activity you have to use the sp_renamedb command.

NOTE:
There is also another way to rename a database which is as-

i) Select the database you have to renameii) Right click on the database and select the option renameiii) Now write the name you want to change

Syntax of rename database

sp_renamedb 'old_database_name' , 'new_database_name'

Example of rename database

sp_renamedb university, collage

Guide:-

In the given example you will get that the database university has renamed as collage. Screen shot is given for your better guide-

Database university name has changed as collage whcih is give in below screen shot for your better guide-

SUMMARY

In this chapter, you have learned about rename database so if you have created a database and want to change its name then you can do with this statement. In the next chapter you will learn about drop database.