Retrieving column comments

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
PhillHS
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 23.05.2007, 14:11
Location: Coventry, UK

Retrieving column comments

Post by PhillHS »

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

Cheers.

Phill.
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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
Image
PhillHS
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 23.05.2007, 14:11
Location: Coventry, UK

Post by PhillHS »

mdaems wrote:select column_comment from information_schema.columns where ...;
Cheers that seems to do what I need :)

Phill.
Post Reply