Warning:
As of October 30, 2020, CockroachDB v19.1 is no longer supported. For more details, refer to the Release Support Policy.
The ALTER INDEX
statement applies a schema change to an index.
Note:
This statement performs a schema change. For more information about how online schema changes work in CockroachDB, see Online Schema Changes.
For information on using ALTER INDEX
, see the documents for its relevant subcommands.
This schema change statement is registered as a job. You can view long-running jobs with SHOW JOBS
.
Subcommand | Description |
---|---|
CONFIGURE ZONE |
Configure replication zones for an index. |
RENAME |
Change the name of an index. |
SPLIT AT |
Force a key-value layer range split at the specified row in the index. |