check data type and maximum length of a field

Hi All,

Is there a way to check the data type and the maximum length of a field?

Look at the INFORMATION_SCHEMA.COLUMN view, it contains the DATA_TYPE as well as either the precision / scale or the maximum allowed characters / bytes per type (where it can be defined manually like VARCHAR)

Jens K. Suessmeyer

http://www.sqlserver2005.de