Hello everybody.
I would like to create a database. It's a structure of about 20
items (tables, views, etc.)
Then I would like to make it a template, because I need 7 copies
of this structure, possibly a growing number.
The only problem is that there are four tables in it, which are
general, so it would be the finest to make them common. For
example in a database "commondb".
But I don't know if I could somehow create a construction like this:
SELECT * from sometable
WHERE somecolumn IN (SELECT * FROM <the-common-db>::atable)
Since now I used Delphi, and I could reference databases as
directories in my file system, so it wasn't a problem.
Any ideas to solve this?
Thanks in advance,
Baldvin