CREATE TABLE t1 (a int, b int, gcol int AS (a + 1) STORED); INSERT INTO t1 (a, b) VALUES (1, 2); SELECT * FROM t1; a b gcol 1 2 2 ALTER TABLE t1 RENAME COLUMN a TO b, RENAME COLUMN b TO a; INSERT INTO t1 (a, b) VALUES (1, 2); SELECT * FROM t1; b a gcol 1 2 3 2 1 2 DROP TABLE t1;