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.
