>>>If it were just a question of display, views might be a good
>>>solution. However, do remember that Firebird system tables
>>>are active -- insert into RDB$RELATIONS and poof! the table
>>>appears. If the system tables
>>
>>And which tool does that?
>>
> QLI, GDEF and the engine do.
> IMO, these tools should be rewroted (if not deprecated) while
> the engine could be changed to use the new tables.

I agree. With a few exceptions only internal tools were brave
enough to try and update metadata tables directly - there were
just too many inconsistencies and possibility to break things.


And anyway, views could still be used. If you want to continue
to let them be updatable then make then updatable with triggers
that pull apart the names etc.

--
Geoff Worboys
Telesis Computing