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 m
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 consi
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
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 th