Table Column DataTypes

select

       o.name,

       OBJECT_NAME(c.OBJECT_ID) TableName

       ,c.name AS ColumnName

       ,SCHEMA_NAME(t.schema_id) AS SchemaName

       ,t.name AS TypeName

       ,t.is_user_defined

       ,t.is_assembly_type

       ,c.max_length

       ,c.PRECISION

       ,c.scale

from sys.objects o

join sys.columns c on o.object_id = c.object_id

join sys.types t on c.user_type_id=t.user_type_id

where c.name = ''

order by o.name