Zeoslib Portal

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

Cheers.

Phill.

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

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

Cheers that seems to do what I need

Phill.