--- In firebird-support@yahoogroups.com, Nick Upson <nick@u...> wrote:

> In article <c60rq5+2sq2@e...>, Alexander V.Nevsky wrote:
> > If usage of "temporary" table is still inavoidable, create and drop
> > is better in the sense of created garbage, but you can't drop table
> > which have dependencies (used in stored procedure, for example). Note
> > you should commit metadata changes before usage in DML too.
>
> Do you still run into the 256 changes limit then you have to backup &
> restore?

Nick, drop/create eleminates modification counter together with
object, it is "alter" which increase this for table. If you
intensively use drop/create table (which is not good), look Ann's
remark about Relation_ID limitation.

Best regards,
Alexander.