470,599 Members | 1,445 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,599 developers. It's quick & easy.

How to view catalog in MySQL

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.

TIA,

kj

Jan 28 '06 #1
2 5383
Kynn Jones wrote:
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.

TIA,

kj

I'm not fimiliar with psql, but you might mean this:

show create table tablename;

see also:
http://dev.mysql.com/doc/refman/5.0/...ate-table.html
http://dev.mysql.com/doc/refman/5.0/en/show.html

Jonathan
Jan 28 '06 #2
Since MySQL 5.0, you'll find this information in the INFORMATION_SCHEMA
database.

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

Markus
Jan 28 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Jefferis NoSpamme | last post: by
reply views Thread by Morten Gulbrandsen | last post: by
1 post views Thread by Chad Reid | last post: by
3 posts views Thread by mike | last post: by
9 posts views Thread by Siddu | last post: by
11 posts views Thread by fishmonger1972 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.