Hello Dmitry,

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

> Another option is to name it 'RDB$SCOPE' and leave external tables in

piece.

And Views? "VIRTUAL"?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com