If you have a table with columns or records you want to use
without damaging the table, for example to perform some test, you can copy the
table to get a new one that is similar but only different by name.
To copy a table in SQL, you can use the following formula:
CREATE TABLE NewTableName AS SELECT * FROM ExistingTable;
Here is an example:
CREATE TABLE Contractors AS SELECT * FROM Employees