databasedistributed-databaseyugabytedb

Does YugaByte DB support online schema changes, especially the ability to add new columns to an existing table

Can you share any information on the impact of an “add column” type of operation when workload is still running/real deployment scenarios? We would like to know about this capability for both YSQL and YCQL APIs of YugabyteDB.

Solution

  • Yes. There is ALTER TABLE support on both YSQL & YCQL.

    https://docs.yugabyte.com/latest/api/ycql/ddl_alter_table/#add-a-column-to-a-table https://docs.yugabyte.com/latest/api/ysql/commands/ddl_alter_table/

    Example: ALTER TABLE employees ADD title TEXT; will add a new title column of type TEXT.