mysql schema

Where (how) is the schema for a table stored in a mysql db?
I would like to expand the attributes assigned to each column of a table by adding a description. My thoughts are to create a new table, called, lets say field_desc with the first column being equal to the "field" of a table definition, with the second being a description of the field.

The problem is I do not know how to access the table definition except with a show table. I would like to join my "new" table with the schema.

Overall objective is to produce a dynamic form based on the definition of a table, but not to use the field names in the form.

Try this code:



Also, you can use the following function:
mysql_field_type()

This will give you information on whether the field is "int", "real", "string", "blob", etc...