Posted by windandwaves on 07/11/05 12:36

NC wrote:
> windandwaves wrote:
>>
>> Is there a way to retrieve the table comment from
>> a mysql table.
>
> Yes. Run a SHOW CREATE TABLE query on the table you want
> to see the comment for. For example, if you have a table
> called `example`, the query will be:
>
> SHOW CREATE TABLE example;
>
> It will return a CREATE TABLE statement for the table,
> which will include the comment. You will need to parse
> it out of the CREATE TABLE statement.
>

Thank you for clarifying this.

- Nicolaas

[Back to original message]