select column_name,data_type,LEN(data_type) from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='table_name'