Hello Jake,
> I would like to use separate databases to group certain related tables
> to keep things clean, but I would also like to use foreign keys to
> enforce referential integrity between tables in different databases. I
> don't think this is possible. Am I right? And if so, am I reduced to
> using carefully chosen table names to keep things organized? What have
> others done in this situation?
Ehm... According to me, all tables related to eachother or a certain
domain should go in 1 database. That is, each database should be
able to exist by itself.
So, in your case, dump everything into 1 database.
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
