Subject | Re: [Firebird-Architect] Temporary tables |
---|---|
Author | Vlad Horsun |
Post date | 2005-06-28T08:23:37Z |
> Sorry if this was already taken into consideration and/or discussed, butIf you talk about global temporary tables (GTT) then there are no
> 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).
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