sp_renamedb ?oldname? , ?newname? alter database ?databasename? modify

What command do we use to rename a db?

Question Posted / swetha

Answer Posted / swetha

sp_renamedb ?oldname? , ?newname?

alter database ?databasename?
modify name = ?newdatabasename?

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between Stored Procedures and triggers?

1078

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1030

Can you type more than one query in the query editor screen at the same time?

1011

What should be the fill factor for indexes created on tables? : sql server database administration

1138

What is a fan-out query in SQL Azure?

121

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

How check triggers in sql server?

990

Is mysql the same as sql server?

983

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1006

How do I find sql server instance name?

959

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

980

What is transaction server distributed transaction?

1054

What is difference between join and natural join?

963

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1143

What happens if the update subquery returns multiple rows in ms sql server?

1123