This version of CockroachDB is no longer supported. For more details, see the Release Support Policy.

The ALTER INDEX statement applies a schema change to an index.

To understand how CockroachDB changes schema elements without requiring table locking or other user-visible downtime, see Online Schema Changes in CockroachDB.

For information on using ALTER INDEX, see the documents for its relevant subcommands.

Subcommand Description
RENAME Change the name of an index.
SPLIT AT Force a key-value layer range split at the specified row in the index.

YesYes NoNo