Hi Thomas,

>>> 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

At the time I'm using a simple solution. There are two generators, one with
the id (PK) and one counts the inserted date. If the second generator
reached a count value, I move the old records in a backup-table like the
year of creating. After this I reset the second generator.



For creating the table I use at the time a simple statement-text
(varchar(5000) with DDL) and execute this, without reading the system
tables. It works but may not be the best solution.



Thanks.



[Non-text portions of this message have been removed]