List table columns and their data types

SELECT
OBJECT_NAME(c.OBJECT_ID) TableName
,c.name AS ColumnName
--,SCHEMA_NAME(t.schema_id) AS SchemaName
,t.name AS Type
,c.max_length as Length
,c.scale
,case when c.is_nullable = 0 then 'No' else 'Yes' end as Nullable
,c.PRECISION
,t.is_user_defined
,t.is_assembly_type
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id=t.user_type_id
WHERE OBJECT_NAME(c.OBJECT_ID) = 'table name'
ORDER BY c.OBJECT_ID;