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
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
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
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
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