sp_renamedb 'oldname','newname' alter database <d

What command do we use to rename a db?

Question Posted / visala

Answer Posted / visala

sp_renamedb 'oldname','newname'

alter database <databasename>
modify name=<newdatabasename>

Is This Answer Correct ?

17 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between DataRow.Delete() and DataRow.Remove()?

740

What is transactional replication?

565

What is fill factor and pad index?

544

What is database white box testing?

680

What is SQL Server?

663

How to attach adventureworkslt physical files to the server?

635

Is null in sql server?

544

How to drop an existing stored procedure in ms sql server?

548

What are different types of statements that are supported by sql?

596

What is the importance of a recovery model?

611

What are locks in sql?

541

What is a periodical index?

510

Define ACID properties in a Database?

630

How to connect to SQL Azure Database by using sqlcmd?

110

What is a partition function in sql server?

537