RE: MYSQL + acquiring table relationships

2005-01-20 Thread SGreen
"Paul Wallace" <[EMAIL PROTECTED]> wrote on 01/19/2005 06:50:48 PM: > Was there a reply to this post? If so, I could have (did) missed it. Can > you please resend? > > Rgds > > Paul. > Sorry, but I never said (woops!) Which language I use depends on where I want to run the script and how

RE: MYSQL + acquiring table relationships

2005-01-19 Thread Paul Wallace
Was there a reply to this post? If so, I could have (did) missed it. Can you please resend? Rgds Paul. Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial

RE: MYSQL + acquiring table relationships

2005-01-17 Thread Dave Merrill
Shawn, what language(s) are you using to parse this? Could you share the code? Thanks, Dave Merrill > I prefer to parse the results of a "SHOW CREATE TABLE..." query. It's > rather trivial to detect which rows in the result of that statement are > your FOREIGN KEYS. They not only indicate which

Re: MYSQL + acquiring table relationships

2005-01-17 Thread SGreen
"Paul Wallace" <[EMAIL PROTECTED]> wrote on 01/17/2005 12:04:13 AM: > Hi, > How can I, if at all, acquire table relationships - in particular > one-to-may/many-to-one relationships? I have looked into the > DatabaseMetaData object (Java) , but have not as yet been able to > acquire the said r