RENAME TABLE¶

RENAME TABLE can be used to rename a table.

Warning

Renaming a table can void existing views that use this table. See more about recompiling views.

Syntax¶

ALTER TABLE [schema_name.]current_name RENAME TO new_name

schema_name ::= identifier

current_name ::= identifier

new_name ::= identifier

Parameter	Description
`schema_name`	The schema name for the table. Defaults to `public` if not specified
`current_name`	The table name to apply the change to
`new_name`	The new table name

ALTER TABLE
  public.users RENAME TO former_users;

The role must have the DDL permission at the database or table level.