How to get data type info for a column?

[Cliff]

Hey there,


I am looking for a way to get the data_type info for each column for several
tables.
Ie I wish to loop over several tables and build a profile of the column type
per table.


Anyone got any advice please?

Cheers :)


Cliff.