Subject Re: [Firebird-Architect] RFC: Proposal for the implementation
Author Dmitry Yemanov
"Martijn Tonies" <m.tonies@...> wrote:
> > First, I propose to rename the suggested RDB$RELATION_TYPE column to
> > RDB$STORAGE_TYPE with possible values of 'PERMANENT', 'GLOBAL TEMPORARY'
> > and 'LOCAL TEMPORARY'. Perhaps, external tables could use the value
> And Views? "VIRTUAL"?

Since views are not stored, I'd expect their RDB$STORAGE_TYPE to be NULL.
Perhaps, some RDB$RELATION_TYPE also makes sense to clearly distinguish
between tables and views (without selecting from RDB$VIEW_RELATIONS), but
this is completely offtopic here.