| Subject | Copy Table |
|---|---|
| Author | |
| Post date | 2014-04-03T15:47:11Z |
Hi,
I want to create monthly backups of some tables by executing a procedure.
For ex, lets say I have a table named as COMPANY, and every month I want to create a backup table named as COMPANY_BCK_2014_01, COMPANY_BCK_2014_02 and copy the existing data into these backup tables.
Can I create a table in a stored procedure by using the DDL of an existing table?
Thank you.