How to Rename a Schema in Redshift database

Use the below command to rename a schema in Redshift where current_schema_name is the current name of the schema and new_schema_name is the new name.

ALTER SCHEMA current_schema_name RENAME TO new_schema_name