If you upgrade to mysql 5.0.x there are also the The INFORMATION_SCHEMA tables that return meta information about tables.
AFAIK they may not be available in pre 5.0 versions. Keith In theory, theory and practice are the same; in practice they are not. To unsubscribe from this list, please see detailed instructions already posted at: http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2 On Fri, 17 Mar 2006, Yves Glodt wrote: > To: mysql@lists.mysql.com > From: Yves Glodt <[EMAIL PROTECTED]> > Subject: getting table metadata > > Hi, > > is it possible to get information about tables by doing queries on some > system > tables? I am using mysql version 4.1.11 on debian sarge. > > In my case I need to know which columns (names and types) a table has, and > how > the primary key is defined. > > How can I get this information out of mysql by only using sql ? > > Best regards, > Yves > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]