RE: query mysql data dictionary

2004-04-23 Thread Dathan Vance Pattishall
SHOW KEYS FROM > -Original Message- > From: sbv chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 7:26 AM > To: [EMAIL PROTECTED] > Subject: query mysql data dictionary > > Hi, I'm trying to find a way to find the primary keys in a table and fin

query mysql data dictionary

2004-04-23 Thread sbv chris
Hi, I'm trying to find a way to find the primary keys in a table and find constraints on a table by sql. I would like to later issue these sql statements through jdbc. hows this done in mysql? Regards, Sunil. _ Lose those love han