This might be a stupid question, but is it possible to have a foreign key reference to a table.column in another database?
E.g.: FOREIGN KEY (parent_id) REFERENCES databasename.parent(id) Probably not, but are there any other ways to enforce such relations? Best regards Tor Rune Skoglund [EMAIL PROTECTED] sql,query,queries,smallint --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
