/
Create a back-up of a selected table
Create a back-up of a selected table
- Sigrid Kviteberg
- Daria Chebotaieva
Owned by Sigrid Kviteberg, created
1 Description | 2 SQL Statement
Summary | This SQL statement will provide you a backup of a selected fields and table. |
|---|---|
Keywords | Back-up |
Description
This can be used when you are to do a larger change in a Production 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.
SQL Statement
Select * into BK_pay_Payroll_20220624
From pw001pay