Page 1 of 1

MySQL metadata

Posted: Wed Apr 20, 2005 9:05 pm
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

Re: MySQL metadata

Posted: Thu Apr 21, 2005 12:17 pm
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).