Thanks to you both, Karam and KH. These suggestions are most helpful. However, my ultimate goal is to find some sort of "query", via a catalog table, that can get arbitrary meta data from within the database. This information will be used in subsequent queries.
Thanks, to you or anyone in the mysql mailing list, for further suggestions (original letter below). --- Karam Chand <[EMAIL PROTECTED]> wrote: > If you are using Windows, a GUI client like SQLyog > would be of great help. It is free, and has neat > interface to display / manage relationships. --- KH Chiu <[EMAIL PROTECTED]> wrote: > There are many ways to lookup MySQL metadata. I was used to familiar > with them. Unluckily, I am 'spoiled' by phpMyAdmin recently. > > I strongly recommend you to have a try with phpMyAdmin. --- Jeff Epstein <[EMAIL PROTECTED]> wrote: > > I've only been using MySQL for a few days, but I'm experienced with > > Oracle. So consider this a sort-of-newbie question. > > > > Is there any way to determine what foreign keys exist on a table? I > > have tried "myisamchk", "describe", "show index", "show create > > table", all to no avail. > > > > Is there complete access to the meta-data? > > > > (I'm using version 3.23.55 on Windows 2000, by the way.) ===== :' ) Jeff Epstein [EMAIL PROTECTED] http://www.jeffyjeffy.com .. __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
