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
