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

How you can move data or databases between servers and databases in sql server?

1099

How to loop through the result set with @@fetch_status?

1429

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

what is checksum in sql server.........???

1744

Explain iaas, paas and saas?

What is function of master database?

116

How to create new tables with "select ... Into" statements in ms sql server?

1046

What is the query and subquery?

1119

What is report subscription?

132

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

2023

Define Unique Key?

1066

can an automatic recovery be initiated by a user? : Sql server administration

991

What is nested transaction?

1137

What is data source in connection string?

955

What is the difference between ‘having’ clause and a ‘where’ clause?

1083