WITH T AS (SELECT T.system_type_id, T.name
        FROM sys.types T, sys.schemas AS S
        WHERE T.schema_id = S.schema_id AND S.name = 'sys')
SELECT
     -- O.object_id AS ObjectID,
     S.name AS [Schema],
     O.name AS Object,
     O.type_desc AS ObjectType,
     C.column_id AS ColumnID,
     C.name AS [Column],
     C.system_type_id AS TypeID,
     T.name + CASE
         WHEN T.name In ('varchar', 'char')
         THEN '(' + CAST(C.max_length AS Varchar(50)) + ')'
         WHEN T.name In ('nvarchar', 'nchar')
         THEN '(' + CAST(C.max_length/2 AS Varchar(50)) + ')'
         WHEN T.name IN ('decimal', 'numeric')
         THEN '(' + CAST(C.precision AS Varchar(50)) + ', ' +  CAST(C.scale AS Varchar(50)) + ')'
         ELSE '' END AS TypeName
FROM sys.all_columns AS C
     INNER JOIN sys.all_objects AS O ON C.object_id = O.object_id
     INNER JOIN sys.schemas AS S ON O.Schema_id = S.Schema_id
     INNER JOIN T ON C.system_type_id = T.system_type_id
WHERE O.name = 'Table2'
ORDER BY S.name, O.name, C.column_id;