SELECT
t.type_desc AS [TYPE],
t.Name AS [TABLE NAME],
c.name AS [COLUMN NAME],
p.name AS [DATA TYPE]
FROM sys.objects T
JOIN sys.columns as C ON t.object_id = c.object_id
JOIN sys.types P ON c.system_type_id=p.system_type_id
WHERE
t.type_desc='USER_TABLE'
OR
t.type_desc='VIEW'
ORDER BY
1,2