ALTER TABLE statement applies a schema change to a table.
For information on using
ALTER TABLE, see the documents for its relevant subcommands.
|Add columns to tables.
|Add constraints to columns.
|Change or drop a column's Default constraint or drop the Not Null constraint.
|Remove columns from tables.
|Remove constraints from columns.
|Change the names of columns.
|Change the names of tables.
|(Documentation pending) Potentially improve performance by identifying ideal locations to split data in the key-value layer.
Viewing Schema Changes New in v1.1
Whenever you initiate a schema change, CockroachDB registers it as a job, which you can view with