On 23/11/2016 11:35, Ivan Přenosil wrote: > Another example - when the table field uses user defined domain, the > same domain will be used by view. > When I alter the table field by changing it to use another wider domain, > the view will retain the original narrow domain. > Yes.
Another approach than change views domains automatically when changing a dependent table, is to work with views and computed fields without needing a domain. Which will break tools wanting to know views structure. And that shows another necessity. Having the system tables as a very low level thing and have virtual tables for the user to access. Virtual RDB$RELATIONS may show to the user the view's columns types. Adriano ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel