Mysql - Getting Table Comment

[vendlus]

When you create a table in mySQL, you can add a comment to it. phpMyAdmin let's you do this as a text field at the bottom of the create table form, and the comment is added to the end of the create table query.

 

My question is how to you retrieve the comment?? I found in the mySQL docs about how to set it in the create table statement, but couldn't find how to actually view it. phpMyAdmin displays it on your page when you view the table, so I know it's possible.

 

Does anyone know? Or can point me to a really good mySQL reference site?

 

*edit* for reference, here is the create table statement so that you can see what I'm talking about. I copied this from the statement phpMyAdmin created. The comment I want to retrieve is at the end.

>CREATE TABLE `test` (
`id` INT( 10 ) NOT NULL ,
`comment` VARCHAR( 50 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
) COMMENT = 'This is a test table.';

 

- Vendlus

[vendlus]

Ugh... this is twice today that I've found my answer within minutes of posting here. (I really did look all morning for this answer before posting too. )

 

Anywhat,

>SHOW TABLE STATUS

does what I want. The comment is one of the fields returned.

 

Thanks anyway to those of you that I know would have answered me.

 

Rock Sign

[Wilexa]

It is the TCH good luck karma at work!

 

If you post, you WILL find an answer soon. Whether from other family members or by yourself!

 

...dave