用友时空CCERP/KSOA/CDM数据字典自生成脚本

--自生成V7/CCERP/KSOA/CDM系列的数据字典
SELECT b.tbname 英文表名,b.chnname 中文表名,a.name as 英文字段名, isnull(c.chnname,'') as 中文字段名,
d.name AS 字段类型,case when a.xtype in (239,231,175,167) then a.length else 0 end as 长度,
case when a.xtype in (239,231,175,167) then '' else cast(a.xprec as varchar)+'.'+cast(a.xscale as varchar) end as 精度
FROM syscolumns a JOIN tblist b(NOLOCK) ON OBJECT_NAME(a.id)=b.tbname AND b.tbtype IN ('资料表','业务表') 
LEFT JOIN fldlist c(NOLOCK) ON a.name=c.fdname
JOIN systypes d ON a.xtype=d.xtype 
--WHERE OBJECT_NAME(a.id)='cwk'
ORDER BY b.tbname,a.colorder