Rename mdb table

Question

Hello

I use Access Database Engine and OleDbReader to work with mdb and accdb files, need to rename a table:

ALTER TABLE <table name> RENAME TO <new table name>

OleDbException, anyway using ADE?

Thanks

Answer 1

Hi @StewartBW ,

Access does not support the RENAME TABLE SQL command.

You can work around this limitation by using a combination of SQL statements to create a new table, copy the data from the old table, and then drop the old table.

1. Use SELECT * INTO {newTableName} FROM {oldTableName} WHERE 1 = 0 statement to create a new table with the same structure as the old table but without copying any data.
2. Use INSERT INTO {newTableName} SELECT * FROM {oldTableName} statement to copy all data from the old table to the new table.
3. Use DROP TABLE {oldTableName} statement to remove the old table from the database.

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.