Allmost there


SELECT
-- OBJECT_name(c.object_id) TableName
c.name AS [COLUMN_NAME]
-- ,SCHEMA_NAME(t.schema_id) AS SchemaName
, t.name AS [DATA_TYPE]
-- ,t.is_user_defined
-- ,t.is_assembly_type
,c.max_length
-- ,c.precision
-- ,c.scale
,c.is_nullable AS [OBLIGATORY]
-- ,value as [DESCRIPTION]
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
-- left join sys.extended_properties AS ep on ep.major_id = c.object_id AND ep.minor_id = c.column_id

ORDER BY DATA_TYPE

SELECT DISTINCT t.name from sys.types as t

select value from sys.extended_properties