USE [db_E23]
GO
/****** Object: Table [dbo].[FieldPropertyDict] Script Date: 2023-02-04 4:03:34 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N’[dbo].[FieldPropertyDict]‘) AND type in (N’U’))
DROP TABLE [dbo].[FieldPropertyDict]
GO
/****** Object: Table [dbo].[FieldPropertyDict] Script Date: 2023-02-04 4:03:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FieldPropertyDict](
[tblName] [sysname] NOT NULL,
[tblDescription] varchar NOT NULL,
[moduleName] varchar NULL,
[moduleCnName] varchar NULL,
[moduleDescription] varchar NULL,
[tbltype] varchar NOT NULL,
[fieldSerialNo] [smallint] NULL,
[fieldName] nvarchar NULL,
[logo] [int] NULL,
[primaryKey] [int] NULL,
[types] [sysname] NULL,
[bytes] [smallint] NOT NULL,
[fieldLength] [int] NULL,
[decimalPlace] [int] NOT NULL,
[isallowedEmpty] [int] NULL,
[defaultValue] nvarchar NOT NULL,
[fieldDescription] varchar NOT NULL,
[fieldComments] varchar NOT NULL,
[fieldFullcomments] varchar NULL,
[Isvisible] [int] NOT NULL,
[fieldcontroltype] varchar NOT NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[FieldPropertyDict]
([tblName]
,[tblDescription]
,[moduleName]
,[moduleCnName]
,[moduleDescription]
,[tbltype]
,[fieldSerialNo]
,[fieldName]
,[logo]
,[primaryKey]
,[types]
,[bytes]
,[fieldLength]
,[decimalPlace]
,[isallowedEmpty]
,[defaultValue]
,[fieldDescription]
,[fieldComments]
,[fieldFullcomments]
,[Isvisible]
,[fieldcontroltype] )
Select [tblName]
,[tblDescription]
,[moduleName]
,[moduleCnName]
,[moduleDescription]
,‘1’
,[fieldSerialNo]
,[fieldName]
,[logo]
,[primaryKey]
,[types]
,[bytes]
,[fieldLength]
,[decimalPlace]
,[isallowedEmpty]
,[defaultValue]
,[fieldDescription]
,[fieldComments]
,[fieldFullcomments]
,‘1’
,‘1’
From [dbo].[View_uTableInfo];