Alter Tables

immudb supports limited table altering. The supported operations are lightweight. They do not require any changes to already written row data and there is no performance penalty on read/write operations in such altered tables.

RENAME TABLE#

An existing table can be renamed. The table with the new name must not exist in the database when performing the alter operation.

1ALTER TABLE customer RENAME TO customers;

ADD COLUMN#

A new column can be added to an existing table. Such column must be nullable. For rows that already existed in the table before the alter operation, the value of the newly added column will be read as NULL. New column can not be set as AUTO_INCREMENT which is only allowed for the primary key.

1ALTER TABLE customers
2ADD COLUMN created_time TIMESTAMP;
3
4SELECT customer_name, created_time
5FROM customers;

RENAME COLUMN#

An existing column can be renamed. The column with the new name must not exist in the table when performing the alter operation. If the column was previously part of an index, such index will continue working with the new column name. Renaming a column does not change column’s type.

1ALTER TABLE customers
2RENAME COLUMN created_time TO created_at;
3
4SELECT customer_name, created_at
5FROM customers;

DROP COLUMN#

An existing column can be deleted. Prior to removing the column, it is necessary to remove any associated indexes.

1ALTER TABLE customers
2DROP COLUMN created_at;