• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 933
  • Last Modified:

Field descriptions

I am trying without success to get the field description from the table fields in a MySQL database into a C# program.

If someone would be so kind as to give me the "dummies" step by step version. I've Googled for it but got nothing I could understand. It seems like it should be something fairly simple. Please help.
1 Solution
If you are using mysql 5

You can go to

Information_Schema.COLUMNS and the COLUMN_COMMENT field

otherwise you can extract it from the show create table - and pull it from there
If you have MySQL 4.1, you can use the SHOW FULL COLUMNS FROM tablename syntax:


If you have 5.0, you can use the information_schema as Raynard7 said.
PadriacAuthor Commented:
Thanks Raynard7! That was just what I needed to get where I wanted. With your answer I was able to put together exactly the code I needed. Thanks again.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now