Hello,

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

Thanks Olaf