ALTER SCHEMA Statement #

ALTER SCHEMA [IF EXISTS] name RENAME TO name

Rename the schema object if it exists.

The operation will recursively rename schemas of the associated objects.

System schemas system and public cannot be altered.

create schema example;
alter schema example rename to example2;
drop schema example2;