changing multiple column names with a single query

Question

in ms-access, how to write a query / DDL to change multiple column names with a single query.

Answer 1

You have to create a new table, copy data, drop old table

ALTER TABLE does not support multiple ...ALTER COLUMN clauses

You could ADD multiple columns on one go, populate then, then drop the old columns. Multiple ADDs are supported.