select * from sysobjects where xtype='u' select * from syscolumns where id='34099162' select * from sysproperties where TableID=34099162 select * from syscomments select * from systypes select 'ID'=a.colorder, '字段名称'=a.name, '数据类型'=c.name, a.xtype, '长度'= COLUMNPROPERTY(a.id,a.name,'PRECISION'), '标识' = case when COLUMNPROPERTY(a.id,a.name,'IsIdentity')=1 then '√'else '' end, '主键' = case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=a.id and name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid))) then '√' else '' end, '允许空'=case when a.isnullable=1 then '√'else '' end, '默认值' = isnull(d.text,''), '备注' = b.PropValue from syscolumns a left join sysproperties b on a.name=b.ColName and a.id=b.TableID left join systypes c on c.xtype=a.xtype left join syscomments d on a.cdefault=d.id left join sysobjects e on e.id=a.id where e.name='Fl_Users' order by 1