Can anybody tell me how to get the datatype and size of a field in a table using SQL or in VB

Thanks in advance
Venky