"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/docs/alter_schema.rst" (6 May 2012, 637 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format (assuming markdown format). Alternatively you can here view or download the uninterpreted source code file. A member file download can also be achieved by clicking within a package contents listing on the according byte size field.

ALTER SCHEMA

ALTER SCHEMA changes the definition of a schema.

You must own the schema to use ALTER SCHEMA. To rename a schema you must also have the CREATE privilege for the database. To alter the owner, you must also be a direct or indirect member of the new owning role, and you must have the CREATE privilege for the database:

ALTER SCHEMA name RENAME TO new_name
ALTER SCHEMA name OWNER TO new_owner

name

The name of an existing schema.

new_name

The new name of the schema.

new_owner

The new owner of the schema.

create_schema and drop_schema