ALTER DATABASE

Warning:
As of May 12, 2021, CockroachDB v19.2 is no longer supported. For more details, refer to the Release Support Policy.

The ALTER DATABASE statement applies a schema change to a database. For information on using ALTER DATABASE, see the pages for its relevant subcommands.

Note:

This statement performs a schema change. For more information about how online schema changes work in CockroachDB, see Online Schema Changes.

Subcommands

Subcommand Description
CONFIGURE ZONE Configure replication zones for a database.
RENAME Change the name of a database.

Viewing schema changes

This schema change statement is registered as a job. You can view long-running jobs with SHOW JOBS.


Yes No