Making copy of a table

[Catalina]

Sometimes extensive updates have to be made to a table using an update query or loop through a record set.

In order to be able to undo changes in case of a mistake I am thinking about the following procedure:

In code:
1 - Make a copy of the table

2 - Make the changes in the original

3 - Check if updates are correct and if so: delete the copy and if not:
delete the default table and rename the copy so it will be the original.

Is that common practice or not?

Thanks

 

[GinaWhipp]

Maybe you should explain what you mean by "...extensive updates...". As a side note, your way will cause extensive bloating and you will need to be constantly compacting your database.

 

[DavidAtWork]

you could just try exporting the table to a separate back-up database, run your updates and then you're able to import back in if need be.

David