On Friday 17 March 2006 15:52, Martijn Tonies wrote: > Hello Yves, Hello Martijn,
> > 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 ? > > Have a look at the SHOW commands in the documentation. I know about the "show create table ..." but it doesn't really satisfy my needs... Is there really no other way apart of parsing "create table" statements? (I needed to this with firebird, and found all I could dream of in the RDB$ tables) Best regards, Yves > As for system tables, MySQL 4.1 hardly has any. > > Martijn Tonies > Database Workbench - development tool for MySQL, and more! > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
