k3 ERP 数据表结构的SQL

 

select distinct f.FNumber as 系统代码, f.FName AS 系统名称,
d.FTableName AS 表名,d.FDescription AS 表说明,a.[name] as 字段代码,c.[name] as 数据类型,
a.[length] as 长度, e.fdescription as 字段说明,e.ffieldnote AS 备注
from syscolumns a
join sysobjects b on a.id = b.id
join systypes c on c.xusertype = a.xusertype
left outer join t_tabledescription d on (d.ftablename=b.name )
left outer join t_subsystem f on(f.fsubsysid=d.fsubsystemid)
left outer join t_fielddescription e on(a.name=e.ffieldname and  d.ftableid=e.ftableid)
where d.ftableid is not null

order by f.FNumber,d.FTableName,a.[name]