CREATE TABLE dbo.workE
(
   H_CODE VARCHAR(6) NULL,
   W_FROM VARCHAR(8) NULL,
   W_TO VARCHAR(8) NULL,
   W_COMPANY VARCHAR(30) NULL,
   W_POST VARCHAR(10) NULL,
   W_MEMO TEXT NULL
)

GO

CREATE INDEX H_CODE ON dbo.workE(H_CODE)

GO

CREATE INDEX CODETO ON dbo.workE(H_CODE,W_TO)

END