Re: How to get meta data info in MySQL

[gerald_clark <suppressed>]

My database editor uses:
describe name;

Karen Chu wrote:

> 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/suppressed