Retrieving column comments

PhillHS · Post by **PhillHS** » 01.10.2008, 10:06

Is there a way of retrieving the column comments from a MySQL 5 database ?

Cheers.

Phill.

Post by **mdaems** » 01.10.2008, 11:04

select column_comment from information_schema.columns where ...;

I didn't test, but it may also be available in the Columns information you get using a TZMetadata component. (If so, I think it's the 12th column)

Mark

PhillHS · Post by **PhillHS** » 03.10.2008, 17:25

mdaems wrote:select column_comment from information_schema.columns where ...;

Cheers that seems to do what I need

Phill.