What command do we use to rename a db?

Answer Posted / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between composite index and covering index?

683


What is index fragmentation in ms sql server?

771


How to define and use table alias names in ms sql server?

746


Explain few of the new features of sql server 2008 management studio

685


What are the different types of backups avaialabe in sql server 2005?

776






What are examples of triggers?

809


How can we solve concurrency problems?

779


What is database dimension? : sql server analysis services, ssas

836


Tell me what is the order in which the sql query is executed?

705


What is the difference between stored procedure and user defined functions?

854


Do you know how to store and query spatial data?

780


How to define output parameters in stored procedures?

709


Why can there be only one clustered index and not more than one?

734


how you can configure a running aggregate in SSRS?

131


How do I find the query plan in sql server?

707