cname

select
c.colid,
c.name as column_name,
t.name as data_type,
c.length,
c.prec,
c.scale,
c.nulls as is_nullable
from syscolumns c
join systypes t on c.usertype = t.usertype
where c.id = object_id('')
order by c.colid;