--- In firebird-support@yahoogroups.com, Sudheer Palaparambil
<p_sudheers@y...> wrote:

> Hi,
>
> I am using some tables (like sybase's temporary
> table) for report generation purpose. I usually
> delete all records from the table on calling
> the SP and fill the table again with the data and
> return the result set.
>
> My question is which one is best suited for FB ?

For FB the best suited is don't use such a table at all but use
stored procedure which returns needed result set.

> To create and drop the table each time or delete
> the record each time ?

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.

Best regards,
Alexander.