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

Explain full-text query in sql server?

542

Can binary strings be converted into numeric or float data types?

561

how to create “alternate row colour”?

109

What are the purposes and advantages stored procedure?

501

List down some advantages of sql stored procedure?

566

How to write a query with an inner join in ms sql server?

554

In which format does an image save in SQL Server database ?

596

How you trouble shoot when any job fails

1509

How to view the error log for any specific instance? : sql server database administration

583

What are the different index configurations a table can have?

519

Define tool Manage Statistics in SQL Server 2000 query ?

528

Is BCNF better than 2NF & 3NF? Why?

625

What happens if ntwdblib.dll is missing on your machine?

639

What are different types of raid configurations? : SQL Server Architecture

576

How important do you consider cursors or while loops for a transactional database?

539