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
>
