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
MySQL metadata
Moderator: General Moderators
-
fractalvibes
- Forum Contributor
- Posts: 335
- Joined: Thu Sep 26, 2002 6:14 pm
- Location: Waco, Texas
Re: MySQL metadata
To my knowledge you can query the 'mysql' database to get the metadata (if you have access to it).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.?