金蝶表结构查询

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  and FTableName='t_ItemDetailV'
order by f.FNumber,d.FTableName,a.[name]