Subject Re: [Firebird-Architect] Temporary tables
Author Vlad Horsun
> Sorry if this was already taken into consideration and/or discussed, but
> it just occured to me. How we would handle dependencies ? I.e. when SP,
> view or trigger would refer to temp. table ? For now, FB doesn't allow
> objects to disappear when there are dependent object(s).

If you talk about global temporary tables (GTT) then there are no
differences between usual (persistent) tables and GTT since GTT's
metadata is persistent. I.e. GTT's metadata don't disappear automagically -
just data.

If you talk about table variables - they declared in procedure or trigger
and again there are no problems since such declarations don't create
dependencies

If you talk about transient datasets (TDS) - should be no way to create
dependence on it since they declarations don't stored in system catalog,
AFAIU

Regards,
Vlad