求字段的数据类型

[FROM]

用SQL语句实现，

表TABLE2有下列字段，ID，NAME，FOUND

查询出FOUND字段的数据类型

[zjcxc]

select 数据类型=a.name from systypes a
join syscolumns b on a.xusertype=b.xusertype
where b.name='FOUND' and object_id('TABLE2')=b.id

[CCEO]

SP_COLUMNS @TABLE_NAME='TABLE2',@COLUMN_NAME='FOUND'

[caiyunxia]

select b.name FROM syscolumns a
left join systypes b on a.xtype=b.xusertype
where id=object_id('zrc_brks') and a.name='FOUND'

[zheninchangjiang]

select name from systypes where xtype=(select xuertype from syscolumns where id=object_id('table2'))