SQL Rename Database
The following command will rename the databaseproperties to real_estate.
PostgreSQL
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.
MySQL
Doesn’t offer an easy way of renaming databases :-(
Oracle
Handles users, schemas, and databases differently. Here is a link to Oracle’s explanation of high level objects like schemas, databases, etc