There are two ways of renaming a table. 1. Create table NewTableName As Oldtablename. (this query copies everything to new table except the constraits.) 2. Rename table NewTableName Oldtablename. (This query simply renames the original table leaving all the data and constraints intact.