ALTER TABLE with MariaDB Enterprise ColumnStore

Overview

MariaDB Enterprise ColumnStore supports the ALTER TABLE statement to alter, change, or modify tables:

  • Enterprise ColumnStore accepts table options in ALTER TABLE statements to alter table characteristics

Compatibility

  • MariaDB Enterprise ColumnStore 5

  • MariaDB Enterprise ColumnStore 6

Table Options

With MariaDB Enterprise ColumnStore, the ALTER TABLE statement can be used to set table options:

ALTER TABLE hq_sales.invoices
   COMMENT='Invoices entered at HQ';