MySQL metadata

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

MySQL metadata

Post by fractalvibes »

It has been a long while since I used MySQL, but out of curiosity (as I don't recall seeing it mentioned before) - does MySQL have a system catalog that can be queried against as in sysobjects/systables/syscolumns/sysindexes/etc.?

Seems some rdbm's nowadays have stored procs that abstract that to cover underlying changes that occur between versions also.

I think my sites are on about MySQL 4.023 or so.

thanks,

fv
User avatar
Weirdan
Moderator
Posts: 5978
Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine

Re: MySQL metadata

Post by Weirdan »

fractalvibes wrote:It has been a long while since I used MySQL, but out of curiosity (as I don't recall seeing it mentioned before) - does MySQL have a system catalog that can be queried against as in sysobjects/systables/syscolumns/sysindexes/etc.?
To my knowledge you can query the 'mysql' database to get the metadata (if you have access to it).
Post Reply