Can we rename a database in SQL Server?
Yes. Definitely, using the command
First, you have to be an exclusive user; use sp_dboption as indicated to establish yourself as the sole user of the database. Then, just call sp_renamedb
sp_renamedb 'olddatabse','newdatabase'