training.sql

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

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