Release History
Help

YMatrix

Quick Start

Deployment

Data Usage

Manage Clusters

Security

Best Practice

Technical Principles

Advanced Features

Guide

SQL Reference

FAQ

ALTER SCHEMA

Change a schema definition.

Synopsis

ALTER SCHEMA name RENAME TO newname

ALTER SCHEMA name OWNER TO newowner

Description

ALTER SCHEMA Changes a schema definition.

Users must have this mode to use ALTER SCHEMA. To rename a schema, the user must also have CREATE privileges for the database. To change the owner, the user must also be a direct or indirect member of the newly owned role, and the role must have CREATE privileges on the database. Note: Superusers automatically have all these privileges.

Parameters

name

  • The name of the existing pattern.

newname

  • The new name of the pattern. New names cannot start with pg_, because these names are reserved for system mode.

newowner

  • New owner of this model.

Compatibility

There is no ALTER SCHEMA statement in the SQL standard.

See also

CREATE SCHEMA, DROP SCHEMA

← Previous
ALTER_RULE
Next →
ALTER_SEQUENCE