SQL Rename Database

The following command will rename the database properties to real_estate.
SQL Server
ALTER DATABASE properties RENAME TO real_estate;

SQL Server

Microsoft’s documentation on renaming a database, and why you should use “single user” mode.


Doesn’t offer an easy way of renaming databases :-(


Handles users, schemas, and databases differently. Here is a link to Oracle’s explanation of high level objects like schemas, databases, etc