Open
Description
Under the legacy schema changer the following is possible
CREATE TABLE old_table1 (
id INT PRIMARY KEY,
name STRING
);
CREATE TABLE old_table2 (
id INT PRIMARY KEY,
description STRING
);
CREATE TABLE old_table3 (
id INT PRIMARY KEY,
created_at TIMESTAMPTZ
);
SET autocommit_before_ddl=off; -- 25.1
BEGIN;
ALTER TABLE old_table1 RENAME TO new_table1;
ALTER TABLE old_table2 RENAME TO new_table2;
ALTER TABLE old_table3 RENAME TO new_table3;
COMMIT;It would be nice if we could provide a single line equivalent in declarative schema changer similar to how we can chain other ALTER:
ALTER TABLE old_table1 RENAME TO new_table1,
old_table2 RENAME TO new_table2,
old_table3 RENAME TO new_table3;Jira issue: CRDB-51549
Epic CRDB-31465