Hi Mark,
Perhaps something along the lines of this would do the trick (you should double check it!);
select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, DATA_TYPE,
'SIZE/PRECISION'= CASE DATA_TYPE
WHEN 'char' then CHARACTER_MAXIMUM_LENGTH
WHEN 'varchar'...