Online DDL Operations Adding members in the middle of the list causes renumbering of existing members, which requires a table copy. The following table provides an overview of online DDL support for generated column operations. For details, see Syntax and Usage Notes. ADD COLUMN  is not an in-place operation for stored columns (done without using a temporary table) because the expression must be evaluated by the server. Rebuilds the table in place. Rebuilds the table in place. •Adding a  STORED  column •Modifying  STORED  column order •Dropping a  STORED  column •Adding a  VIRTUAL  column ALTER TABLE t1 ADD COLUMN (c2 INT GENERATED ALWAYS AS (c1 + 1) VIRTUAL), ALGORITHM=INSTANT; ALTER TABLE t1 DROP COLUMN c2, ALGORITHM=INPLACE, LOCK=NONE; ALTER TABLE t1 MODIFY COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED FIRST, ALGORITHM=COPY; ALTER TABLE t1 ADD COLUMN (c2 INT GENERATED ALWAYS AS (c1 + 1) STORED), ALGORITHM=COPY; 3183 Syntax and Usage Notes Generated Column Operations Table 15.19 Online DDL Support for Generated Column Operations Operation Instant In Place Rebuilds Table Permits Concurrent DML Only Modifies Metadata Adding a STORED  column No No Yes No No Modifying STORED  column order No No Yes No No Dropping a STORED  column No Yes Yes Yes No Adding a VIRTUAL column Yes Yes No Yes Yes Modifying VIRTUAL column order No No Yes No No Dropping a VIRTUAL column Yes Yes No Yes Yes