Does anyone know how to create a table that has two columns: databasename, tablename that would list the databases and the tables in the databases? I need to do this in a sql statement to create a reference table similar to that of sysobjects in SQL Server or similar to the user_tables in Oracle? Is there a way to do this?
--------------------------------------------------------------------- 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