In contrast, adding a column that allows NULL values and does not specify a default value is a metadata operation only, and involves no locks. When you use CREATE TABLE or ALTER TABLE, database and ...

Fixes cockroachdb#32917. This PR adds support for the add column references statement by allowing the foreign key building code to use columns and indexes added in the current txn. The schema changer ...

When you alter the attributes of a column and an index has been defined for that column, the values in the altered column continue to have the index defined for them. If you drop a column with the ...