training.sql

vfp数据库应用编程

CREATE TABLE dbo.training
(
   H_CODE VARCHAR(6) NULL,
   T_FROM VARCHAR(8) NULL,
   T_TO VARCHAR(8) NULL,
   C_NAME VARCHAR(30) NULL,
   T_SCORE VARCHAR(10) NULL,
   T_MEMO TEXT NULL
)

GO

CREATE INDEX H_CODE ON dbo.training(H_CODE)

GO

CREATE INDEX T_TO ON dbo.training(T_TO)

GO

CREATE INDEX CODETO ON dbo.training(H_CODE,T_TO)

END