How to view catalog in MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
How can I query mysql to view the catalog?  (By the catalog I mean the
special internal database that holds the meta-information about all
other databases in the system, including descriptions of all the tables
and their fields.)  I know how to do this in psql, so I imagine there
is a similar facility in mysql.  FWIW, my OS is Linux.



Re: How to view catalog in MySQL

Kynn Jones wrote:
Quoted text here. Click to load it
I'm not fimiliar with psql, but you might mean this:

show create table tablename;

see also:


Re: How to view catalog in MySQL

Since MySQL 5.0, you'll find this information in the INFORMATION_SCHEMA

Before MySQL 5.0, you can only use some pre-defined SHOW commands.


Site Timeline