Description
This can be used when you are to do a larger change in a Produciton database and you want to have a backup of the affected tables in case something goes wrong, or just for look-up purposes of previous values before an update or deletion.
Selection
Select * into BK_pay_Payroll_20220624
From pw001pay