select sql_variant_property(ID,'BaseType') from tb
--方法2
复制代码 代码如下:
select object_name(ID)表名, c.name 字段名, t.name 数据类型, c.prec 长度 from syscolumns c inner join systypes t on c.xusertype=t.xusertype where objectproperty(id,'IsUserTable')=1 and id=object_id('tb')