select sc.name,st.name
from syscolumns sc left join systypes st
on sc.xtype=st.xtype
where id=object_id('表名') and sc.name='字段名'
select sc.name,st.name
from syscolumns sc left join systypes st
on sc.xtype=st.xtype
where id=object_id('表名') and sc.name='字段名'