hshift.sql

来自「vfp数据库应用编程」· SQL 代码 · 共 23 行

CREATE TABLE dbo.hshift
(
   H_CODE VARCHAR(6) NULL,
   HS_FROMJ VARCHAR(6) NULL,
   HS_TOJ VARCHAR(6) NULL,
   HS_DATE VARCHAR(8) NULL,
   HS_REASON VARCHAR(10) NULL,
   HS_MEMO TEXT NULL,
   HS_FROMB VARCHAR(20) NULL,
   HS_TOB VARCHAR(20) NULL
)

GO

CREATE INDEX H_CODE ON dbo.hshift(H_CODE)

GO

CREATE INDEX HS_DATE ON dbo.hshift(HS_DATE)

END