新增文章

文章标题分类内容

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

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

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--【视图】a_BillField  数据表字段描述

create view dbo.a_BillField
   as 
   select 
       a1.colid
      
      ,isnull(a2.FTableCaption ,'')  FTableCaption
      
      ,a1.FTableName +'.'+ a1.FFieldName + ' '+ isnull(a2.FFieldCaption ,'')  FFullName
      
      ,a1.FDataType
       
      ,a1.FFieldName
      
      ,a1.xtype
      ,a1.FTableName
      
      ,isnull(a2.FFieldCaption ,'')  FFieldCaption
      
      ,isnull(a2.FFieldNote         ,'')  FFieldNote
      ,isnull(a2.FLookUpType        ,'')  FLookUpType
      ,isnull(a2.FLookUpClassID     ,'')  FLookUpClassID
      ,isnull(a2.FSRCTableName      ,'')  FSRCTableName
      ,isnull(a2.FSRCFieldName      ,'')  FSRCFieldName
      ,isnull(a2.FDSPFieldName      ,'')  FDSPFieldName
      ,isnull(a2.FFNDFieldName      ,'')  FFNDFieldName
      ,isnull(a2.FNeedFilter        ,'')  FNeedFilter
      ,isnull(a2.FCanInput          ,'')  FCanInput
      ,isnull(a2.FMustInput         ,'')  FMustInput
      ,isnull(a2.FFormat            ,'')  FFormat
      ,isnull(a2.FSubSystemID       ,'')  FSubSystemID
      ,isnull(a2.FTableID           ,'')  FTableID
      ,isnull(a2.FTableNote         ,'')  FTableNote
      ,isnull(a2.FTableSefDefSign   ,'')  FTableSefDefSign
      ,isnull(a2.FTableType         ,'')  FTableType
      ,isnull(a2.FFieldSefDefSign   ,'')  FFieldSefDefSign
      ,isnull(a2.FFieldType         ,'')  FFieldType

from      a_TableField  a1
   FULL join a_TableDesc   a2 on a2.FTableName = a1.FTableName AND a2.FFieldName = a1.FFieldName
   
/*
------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from a_BillField  where FTableName LIKE '%SEOrder%' AND FTableCaption LIKE '%%'  order by FTableName,colid   --【数据表】【字段描述】

------------------------------------------------------------------------------------------------------------------------------------------------------------------------

select * from t_TableDescription
   select * from t_FieldDescription where ftableid = 11
   
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
*/
go