Warning:
As of May 10, 2022, CockroachDB v20.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. |
CONVERT TO SCHEMA |
New in v20.2: Convert a database to a schema. |
OWNER TO |
New in v20.2: Change the owner of 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
.