I want to be able to get all table names in a database and all the column names and associated data type from a particular table. I wonder how to do that in MySQl. I understand I can use "show tables" to see the table info, but I want to be able to do 'select' in order to get the results back. I want to know if there is something like "select name from sysobject" in Sybase or "select name from all_tables" in Oracle.
Thanks. I would appreciate any advice. Karen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]