ALTER TABLE with MariaDB Enterprise Server

Overview

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

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

  • Enterprise Server allows concurrent read and write queries during ALTER TABLE statements

Compatibility

  • MariaDB Enterprise Server 10.2

  • MariaDB Enterprise Server 10.3

  • MariaDB Enterprise Server 10.4

  • MariaDB Enterprise Server 10.5

  • MariaDB Enterprise Server 10.6

Table Options

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

ALTER TABLE hq_sales.invoices
   ROW_FORMAT=DYNAMIC;