What command do we use to rename a db?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / latha sree

5 Answers
12414 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What command do we use to rename a db?..

Answer / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Is This Answer Correct ?

17 Yes

0 No

What command do we use to rename a db?..

Answer / swetha

sp_renamedb ?oldname? , ?newname?

alter database ?databasename?
modify name = ?newdatabasename?

Is This Answer Correct ?

7 Yes

0 No

What command do we use to rename a db?..

Answer / latha sree

sp_renamedb ?oldname? , ?newname?

Is This Answer Correct ?

7 Yes

1 No

What command do we use to rename a db?..

Answer / karthick.r

sp_rename olddatabasename newdatabasename
for eg
sp_rename prodetails empdetails;

in this eg the name of the prodetails is changed into
empdetails using above command

Is This Answer Correct ?

2 Yes

1 No

What command do we use to rename a db?..

Answer / babuli

To rename a SQL database follow the these seps:

1. Alter database to single user mode. So that all the
active connection will be terminated. (Database properties
-> options > single usermode)
2. Then rename the database using sp_renamedb oldname, newname

Is This Answer Correct ?

1 Yes

0 No

Post New Answer