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