Because tables should create automatically every year.
I am planning now, I will create one template table and copy it every year automatically

--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:
>
> Ahmet Nuri D wrote:
> > Hi, I want to copy table in store procedure, whith all trigers, generators. How can i do that?
>
> Use system tables to extract metadata info and build DML and then
> execute it with EXECUTE STATEMENT.
>
> If structure is "fixed", it's easier to dump the DML using some tool and
> then EXECUTE STATEMENT.
>
> Why do you want to do it in a procedure?
>
>
> --
> Milan Babuskov
>
> ==================================
> The easiest way to import XML, CSV
> and textual files into Firebird:
> http://www.guacosoft.com/xmlwizard
> ==================================
>