gl_data_dictionary.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 26 行

if object_id('dbo.GL_Data_Dictionary') is not null
drop table dbo.GL_Data_Dictionary
go

Create table GL_Data_Dictionary
(
 Itemseq int identity(1,1) not null primary key,
 Object    varchar(255) not null,
 Item      int not null default 1,
 Field     varchar(255) null,
 identify_flag  char(2) null,
 Pkey      char(2) null,
 Field_Type VARCHAR(255) NULL,
 use_space int ,
 length    int ,
 prec      int,
 NilAllow  char(2) null,
 default_value varchar(255) null,
 Remark   varchar(255) null
)
go