> 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.
Unfortunately, Firebird doesn't support the CTAS (CREATE TABLE ... AS SELECT ...) syntax. Feel free to vote on that tracker issue: http://tracker.firebirdsql.org/browse/CORE-796 -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
