SQL Rename Database

OBJECTIVE

In this chapter you will learn:

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 rename
ii) Right click on the database and select the option rename
iii) Now write the name you want to change

Syntax of rename database

Example of rename database

Guide:-

In the given example you will get that the database university has renamed as collage. Screen shot is given for your better guide-
rename-database
Database university name has changed as collage whcih is give in below screen shot for your better guide-
database name has changed

 

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.


Leave a Reply

Your email address will not be published. Required fields are marked *