gen. include file for column definitions??

Hi there,

I'm looking for a way to generate a C include file with the column length definitions of all varchar fields in a database. The result should look like

#define MAX_<TABLENAME>_<COLNAME> <COLUMNLENGTH>+1

where TABLENAME is the name of the table, COLNAME the name of the column and COLUMNLENGTH the length of the varchar field.

Does such a tool already exist or is there a simple SELECT to retrieve the information needed?

Any input welcome and TIA,

-- 
Dietmar Leibecke
----------------
Address is altered to discourage junk mail.
Remove ".---" for the real address.