CDM系统数据结构生成脚本
SELECT case when a.colid=1 then b.tbtype else '' end as 库表类型,
case when a.colid=1 then object_name(a.id) else '' end AS 英文表名,
case when a.colid=1 then isnull(b.chnname,'') else '' end as 中文表名,
a.name AS 英文字段名,isnull(c.chnname,'') as 中文字段名,
case when d.name IN ('decimal','numeric','float') THEN d.name+'('+CAST(a.xprec AS VARCHAR)+','+CAST(a.xscale AS VARCHAR)+')'
WHEN d.name LIKE '%char%' THENd.name+'('+CAST(a.length AS VARCHAR)+')' ELSE d.name END AS 字段类型
FROM syscolumns aJOIN tblist b ON OBJECT_NAME(a.id)=b.tbname
LEFT JOIN fldlist c ON a.name=c.fdname
JOIN systypes d ON a.xtype=d.xtype
ORDER BY b.tbtype desc,OBJECT_NAME(a.id),a.colid
1420110988
好资料,别沉了!
学习,支持。。。 支持,支持!:lol:lol:lol:lol:lol:lol:lol:lol:lol:lol:lol:lol 多谢分享,很地道!!!
页:
[1]