select into statement

select into statement

Hello developers of zoho db

i'm trying to make this statement work but it will not work.

select * into newyear-table from thisyear-table;

what am i doing wrong or is this statement not supported?

Is there a workaround so that i can create backup tables?

thanks for your time

Hans van Hal