Changing the composition of columns
YDB supports adding columns to row and column tables, as well as deleting non-key columns from tables.
ADD COLUMN
— adds a column with the specified name and type. The code below will add a column named views
with data type Uint64
to the episodes
table.
ALTER TABLE episodes ADD COLUMN views Uint64;
DROP COLUMN
— deletes a column with the specified name. The code below will delete the column named views
from the episodes
table.
ALTER TABLE episodes DROP COLUMN views;