ALTER SCHEMA

Synopsis

ALTER {SCHEMA|DATABASE} name RENAME TO new_name

Description

Change the definition of an existing schema.

Examples

Rename schema web to traffic:

ALTER SCHEMA web RENAME TO traffic
ALTER DATABASE web RENAME TO traffic

Limitations

Some connectors do not support renaming schema, such as Hive Connector. See connector documentation for more details.

See Also

create-schema