sql查询表内容

select sysobjects.name as tb_name,syscolumns.name as col_name,systypes.name as col_type,syscolumns.length as col_len,isnull(sysproperties.value,syscolumns.name) as col_memo,case when syscolumns.name in (select 主键=a.name from syscolumns a inner join sysobjects b on a.id=b.id and b.xtype='u' and b.name<>'dtproperties' where exists(select 1 from sysobjects where xtype='pk' and name in (select name from sysindexes where indid in( select indid from sysindexkeys where id = a.id and colid=a.colid ))) and b.name=sysobjects.name ) then '是' else '' end as is_key from sysobjects,systypes,syscolumns left join sysproperties on (syscolumns.id = sysproperties.id and syscolumns.colid = sysproperties.smallid) where (sysobjects.xtype='u' or sysobjects.xtype='v') and sysobjects.id = syscolumns.id and systypes.xtype = syscolumns.xtype and systypes.name <> 'sysname' and sysobjects.name='nd_kcl' and syscolumns.name<>'id' and right(syscolumns.name,1)<>'1' order by syscolumns.colid


查询结果

id	int	8	唯一标识
kclbh	varchar	50	库存笼编号
kclzt	varchar	50	库存笼状态
szfj	varchar	50	所在房间
jlrq	datetime	8	建笼日期
jkjb	varchar	50	健康级别
xsbh	varchar	5000	小鼠编号
cjr	varchar	50	创建人
cjrq	datetime	8	创建日期
flag	varchar	50	动作标识
kcsx	int	4	库存上限
gly	varchar	50	管理员