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 :-(


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