新增文章

文章标题分类内容

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】 删除

if exists (select * from sys.views where object_id = OBJECT_ID(N'dbo.a_TableDesc'))
              drop     view                                         dbo.a_TableDesc
   go

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_TableDesc 金蝶老单字段描述

create view dbo.a_TableDesc
   as 
   select 
          RTRIM( a1.FTableName  )  FTableName 
         ,RTRIM( a1.FDescription)  FTableCaption
         
         ,RTRIM( a2.FFieldName  )  FFieldName
         ,RTRIM( a2.FDescription)  FFieldCaption
         
         ,RTRIM( isnull( a2.FFieldNote,'') ) FFieldNote
         
         ,a2.FLookUpType
         ,a2.FLookUpClassID
         
         ,a2.FSRCTableName
         ,a2.FSRCFieldName
         ,a2.FDSPFieldName
         ,a2.FFNDFieldName
         
         ,a2.FNeedFilter
         ,a2.FCanInput
         ,a2.FMustInput
         ,a2.FFormat
         
         ,a1.FSubSystemID   
          
         ,a1.FTableID     
         ,RTRIM( a1.FTableNote ) FTableNote
         
         ,a1.FSefDefSign   FTableSefDefSign
         ,a1.FType         FTableType
         
         ,a2.FSefDefSign   FFieldSefDefSign  
         ,a2.FType         FFieldType
   
   
   from t_TableDescription  a1
   join t_FieldDescription  a2 on a1.FTableID = a2.FTableID

/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_TableDesc   where FTableCaption LIKE '%销售订单%'  order by FTableName,FFieldName   -- 金蝶老单字段描述
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from t_TableDescription
   select * from t_FieldDescription
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go