ALTER INDEX

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.

SubcommandDescription
CONFIGURE ZONEConfigure replication zones for an index.
RENAMEChange the name of an index.
SPLIT ATForce a key-value layer range split at the specified row in the index.

Was this page helpful?
YesNo