Re: How to determine foreign keys? Meta data?
Jeff, MySQL does not have system tables from where you could query metadata with ordinary SELECT queries. You have to use SHOW CREATE TABLE tablename. If you do not see your foreign key definitions in SHOW CREATE TABLE, then you probably are using MyISAM tables, which do not support foreign keys. InnoDB type tables support foreign keys and print them in SHOW CREATE TABLE, if you have a fairly recent MySQL version. Regards, Heikki Innobase Oy sql query Subject: Re: How to determine foreign keys? Meta data? From: Jeff Epstein Date: Thu, 20 Feb 2003 05:48:25 -0800 (PST) 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). - 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
Re: How to determine foreign keys? Meta data?
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
Re: How to determine foreign keys? Meta data?
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. --- Jeff Epstein <[EMAIL PROTECTED]> wrote: > Hello all. > > 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, by the way.) > > > Thanks! :' ) > > = > :' ) > Jeff Epstein > [EMAIL PROTECTED] > http://www.jeffyjeffy.com > > > .. > > __ > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.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 > __ 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
Re: How to determine foreign keys? Meta data?
Dear Jeff, 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. Regards, > Hello all. > > 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, by the way.) > > Thanks! :' ) > > = > :' ) > Jeff Epstein > [EMAIL PROTECTED] > http://www.jeffyjeffy.com > > .. > > __ > Do you Yahoo!? > Yahoo! Shopping - Send Flowers for Valentine's Day > http://shopping.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 > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Yours, KH Chiu C&A Computer Consultants Ltd. Tel: 3104 2070 Fax: 3010 0896 Email: [EMAIL PROTECTED] Website: www.caconsultant.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
How to determine foreign keys? Meta data?
Hello all. 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, by the way.) Thanks! :' ) = :' ) Jeff Epstein [EMAIL PROTECTED] http://www.jeffyjeffy.com .. __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.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
