---
name: "alter_schema"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/alter_schema"
---

# alter\_schema(7)

change the definition of a schema

## NAME

ALTER SCHEMA - change the definition of a schema

## SYNOPSIS

```
ALTER SCHEMA name RENAME TO newname

```

## DESCRIPTION

**ALTER SCHEMA** changes the definition of a schema. The only functionality is to rename the schema. To rename a schema you must own the schema and have the privilege CREATE for the database.

## PARAMETERS

- *name*

  Name of a schema

- *newname*

  The new name of the schema

## COMPATIBILITY

There is no **ALTER SCHEMA** statement in the SQL standard.

## SEE ALSO

CREATE SCHEMA \[[**create\_schema**(7)](/create_schema/7.md)\], DROP SCHEMA \[**drop\_schema**(l)\]