List:General Discussion« Previous MessageNext Message »
From:Косов Евгений Date:March 17 2006 3:36pm
Subject:Re: getting table metadata
View as plain text  
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
> 
Thread
getting table metadataYves Glodt17 Mar
  • Re: getting table metadataMartijn Tonies17 Mar
    • Re: getting table metadataYves Glodt17 Mar
      • Re: getting table metadataКосов Евгений17 Mar
      • RE: getting table metadataGordon17 Mar
  • Re: getting table metadatamysql17 Mar
  • Re: getting table metadataMartijn Tonies17 Mar
    • Re: getting table metadataYves Glodt17 Mar