modulation.sql

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

CREATE TABLE dbo.modulation
(
   H_CODE VARCHAR(6) NULL,
   M_FROM NUMERIC(8,2) NULL,
   M_TO NUMERIC(8,2) NULL,
   M_DATE VARCHAR(8) NULL,
   M_REASON VARCHAR(10) NULL,
   M_MEMO TEXT NULL
)

GO

CREATE INDEX H_CODE ON dbo.modulation(H_CODE)

GO

CREATE INDEX M_DATE ON dbo.modulation(M_DATE)

GO

CREATE INDEX CODEDATE ON dbo.modulation(H_CODE,M_DATE)

END