"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
> > 'EXTERNAL'.
>
> 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.


Dmitry