Try "DESC table_name".
Yves Glodt пишет:
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]
