Subject Re: [firebird-support] Firebird - Any way to query between databases
Author Hannes Streicher
Guten Tag Craig_Cox@...,

there is someting called external tables that could fit your requirement

however i dont think that this will work if they are accessed from multiple databases concurrently

> I have a growing number of databases with essentially the same table structures that must remain as separate entities. However, a large number of the tables in these
> databases house exactly the same valid values (Lookup Tables). If I add a new valid value, I migrate through each database to update the tables as needed. I would love to have
> a single valid value database that only held these tables and have all my other databases query the valid value database for the information. As I understand it, this is not
> possible at this point in time. Are there any plans that will permit this in future versions of Firebird?

Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...