Re: sql to retrieve column and table comment

[Mike Hillyer]

SHOW FULL COLUMNS FROM test;

That will return a column named 'Comment' that can be used for column comments, and SHOW CREATE TABLE returns the initial CREATE TABLE statement, which you could parse for the comment of the table.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]
Mobile: [phone]
Blog: http://www.openwin.org/mike