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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]