数据字典（SQL2000）

--*****************************************************
--     表字段大全       整理：sdhdy     日期：2004-01-01   
--*****************************************************

 SELECT  
 表名=d.name, 
 表说明=isnull(f.value,''), 
 字段序号=a.colorder, 
 字段名=a.name, 
 标识=case when a.colstat=1 then '√'else '' end, 
 主键=case when exists(select 1 from sysindexes y,sysindexkeys z 
 where y.id=z.id and y.indid=z.indid 
 and z.id=a.id and z.colid=a.colid and y.status & 2948=2048) 
 then '√'else '' end, 
 类型=b.name, 
 占用字节数=a.length, 
 精度=a.prec, 
 小数位数=isnull(a.Scale,0), 
 允许空=case when a.isnullable=1 then '√'else '' end, 
 默认值=isnull(e.text,''), 
 字段说明=isnull(g.[value],'') 
 FROM syscolumns a 
 left join systypes b on a.xtype=b.xusertype 
 inner join sysobjects d on a.id=d.id  and d.xtype='U' 
 and d.name<>'dtproperties' 
 left join syscomments e on a.cdefault=e.id 
 left join sysproperties g on a.id=g.id and a.colid=g.smallid  
 left join sysproperties f on a.id=f.id and f.smallid=0  
 where d.name='tablename'  --如果只查询指定表,加上此条件 
 order by a.id,a.colorder