SELECT OBJECT_NAME(object_id) Table_Name, c.name Column_Name, t.name Field_Type,
   t.name + CASE WHEN t.name IN ('char', 'varchar','nchar','nvarchar') THEN '('+
             CASE WHEN c.max_length=-1 THEN 'MAX'
                  ELSE CONVERT(VARCHAR(4),
             CASE WHEN t.name IN ('nchar','nvarchar') THEN  c.max_length/2 ELSE c.max_length END ) END +')'
             WHEN t.name IN ('decimal','numeric') THEN '('+ CONVERT(VARCHAR(4),c.precision)+',' + CONVERT(VARCHAR(4),c.Scale)+')' ELSE '' END   AS Field_Type_Detail
   FROM sys.columns c    INNER JOIN    sys.types t ON c.user_type_id = t.user_type_id
   WHERE    object_id = OBJECT_ID('LG_013_ITEMS') OR  object_id = OBJECT_ID('L_CAPIDIV')