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 are the differences between stored procedure and view in sql server?

635


How can you stop stored procedures from recompiling?

496


SQL Server Architecture ?

1944


What do you mean by an execution plan? How would you view it?

504


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

546






What is the tcp/ip port on which sql server runs?

574


Mention the differences between having and where clause.

568


What is sharding?

88


What is the exact numeric data type in sql?

558


How to write an inner join with the where clause in ms sql server?

563


What is the most common trace flags used with sql server?

528


What is a data collection table?

550


List out what other servers you can use with ssrs?

93


Explain the database you used in your final year project?

550


How to list all objects in a given schema?

575