>>> Hello,
>>>
>>> I would like to save the old records in a separate table every year.
>>> On the
>>> end of the year I would Copy the empty main-table to an new table
>>> named like "Backup" and the old year for example. The new backup table
>>> needs no triggers.
>>>
>>> How can I realize this?
>>>
>> What's the problem?
>>
>> Kjell
>>
> I would not use a text-based ddl-string, the main-table has many columns. Is
> there a simple solution available? For example ""copy"" table etc.

No direct DDL statement, but if this can involve user interaction via a
tool, use "Duplicate Table" in Database Workbench, but you know, I'm
biased. ;-)


Regards,
Thomas