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
>>> 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,
>>> 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"
> (I needed to this with firebird, and found all I could dream of in the RDB$
> Best regards,
>> As for system tables, MySQL 4.1 hardly has any.
>> Martijn Tonies
>> Database Workbench - development tool for MySQL, and more!
>> Upscene Productions
>> My thoughts:
>> Database development questions? Check the forum!