SELECT 
   T01.object_id
   ,T01.name
   ,T01.column_id
   ,T01.system_type_id
   ,T01.user_type_id
   ,T01.max_length
   ,T01.precision
FROM
   sys.columns T01