sql2008导出表的字典结构

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