select o.name,c.name,t.name,c.column_id,c.system_type_id,c.user_type_id,t.system_type_id,t.user_type_id
from sys.all_columns as c, sysobjects as o, sys.types as t
where o.name in ('YourTalbe1','YourTable2')
and o.id = c.object_id
and c.user_type_id = t.user_type_id
order by o.name,c.column_id