version 11.3
ALTER SCHEMA sql_name RENAME TO sql_name
Description
The ALTER SCHEMA command can be used to rename the sql_name (first parameter) SQL schema to sql_name (second parameter).
Only the database Designer and Administrator can modify schemas.
Example
Renaming of the MyFirstSchema schema to MyLastSchema:
ALTER SCHEMA MyFirstSchema RENAME TO MyLastSchema
See Also