sql查询表的所有字段和表字段对应的类型

1.查询表的所有字段

select syscolumns.name from syscolumns where id=object_id('写上要查询的表名')

2.查询表的所有字段+表字段对应的类型

select syscolumns.name,systypes.name from syscolumns,systypes where syscolumns.xusertype=systypes.xusertype

and syscolumns.id=object_id('写上要查询的表名')

3.查询表的所有字段+表字段对应的类型+类型的长度

select syscolumns.name,systypes.name,systypes.name+'('+cast(syscolumns.length/2 as varchar(10))+')',

syscolumns.length 

from syscolumns,systypes

where syscolumns.xusertype=systypes.xusertype and syscolums.id=object_id('写上要查询的表名')