How to change the Database Name

DatabaseOfNameYou can change the database name according to your habits. The following describes how to change the database name.

Step 2

Click Start in Windows and select programs. Select Microsoft SQL Server console from the list.

Step 2

Change the name. Right-click the Database Name and select "RENAME" from the menu. This prompt is displayed in a new name, and then press Enter ".

Step 2

Internal functions are provided by SQL Server 2005 and 2000. This syntax changes the name of the database for the following features:

Sp_renameDB '','' of Exec '',''

Replace "" with the current name of the database. Replace "" with the new name of the selected database.

Step 2

Run the "modify" command. The "change" command in the SQL Server Workspace can be used for all versions of SQL Server. The syntax for "change" is as follows:

Change Database modification name =

Replace "" with the current name of the database, and replace "with the new name you selected ".

The change of database name is relatively simple in database knowledge. It can be considered as an entry-level knowledge and is suitable for beginners to learn. It is hoped that the modification of the database name introduced in this article will be helpful for beginners.