Views:

Run this statement against the GP database to back up a specific table:

select * into CM20500BACK from CM20500

Replace the CM20500 in both places with whatever table that is being backed up. To keep the back up name unique, add a date so that the script looks like this for example:

select * into CM20500BACK_8_31_20 from CM20500
 

Keywords: SQL, Back up table