You are about to modify a Table in CoreTrac, and you want to make a Back up of that table to avoid losing data.
To back up a table, complete the following steps:
- Take note of the Name of the Table you want to backup. (From now on, we will call it Name_of_the_existent_table).
- Take note of the ticket number, if you created one.
Agents only: take note of the ticket number created by the customer.
- Build the name of the new table in the database: To do so, add the Name_of_the_existent_table and the ticket number, if you created one. If you did not, you can add another number like a date, for ordering purposes. We will call this new table's name, the Name_of_new_table from now on.
- Execute the following query in the Database:
select * into Name_of_new_table from Name_of_the_existent_table
You can find more examples in the w3Schools article related to SQL SELECT INTO sentence.