SQL Rename Schema
The following command will rename properties to real_estate
-- Works for PostgreSQL
ALTER SCHEMA properties RENAME TO real_estate;
SQL Server, MySQL
Don’t offer an easy way of renaming schemas :-(
Oracle
Handles users, schemas, and databases differently. Here is a link to Oracle’s explanation of high level objects like schemas, databases, etc