changing multiple column names with a single query

in ms-access, how to writ开发者_开发问答e a query / DDL to change multiple column names with a single query.

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.