Subject RE: [firebird-support] Set generator values in Stored Procedure
Author Alan McDonald
> I have a stored procedure that I use to empty out tables and set up an
> empty Database.
> Is there any way of setting generator values (to 0) in a stored procedure?
> Dropping and recreating the DB every time I want to reset it is a
> REAL pain
> in the neck ...
> And so is dropping and recreating the generators, tables, and associated
> triggers.
> Regards
> Tim

why don't you just run a script?