SqlServer表字段查询

--查询表字段和字段类型

select syscolumns.name,systypes.name from syscolumns,systypes where syscolumns.xusertype=systypes.xusertype
and syscolumns.id=object_id('p5010_case')

 

--查询表字段和字段类型and 类型长度

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 syscolumns.id=object_id('p5010_case')

posted @ 2020-01-06 14:27  LieJimmy  阅读(1310)  评论(0)  编辑  收藏  举报