On Tue, 12 Jun 2012 10:36:57 +0200, "Olaf Kluge" <olaf.kluge@...>
wrote:

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

If it is just for backup, why not just create a single backup table and
move all records into that table at year end. Then there is no need to
create a table per year (and it is easier to provide a unified view on
'archived' records).

Mark