attend.sql

vfp数据库应用编程

CREATE TABLE dbo.attend
(
   H_CODE VARCHAR(6) NULL,
   A_DATE VARCHAR(8) NULL,
   A_TIMEM VARCHAR(8) NULL,
   A_TIMEA VARCHAR(8) NULL,
   A_KIND VARCHAR(8) NULL,
   A_UNITS NUMERIC(5,2) NULL,
   A_TIMES NUMERIC(3,1) NULL
)

GO

CREATE INDEX LINK1 ON dbo.attend(A_KIND)

GO

CREATE INDEX A_KIND ON dbo.attend()

GO

CREATE INDEX A_DATE ON dbo.attend()

GO

CREATE INDEX H_CODE ON dbo.attend()

GO

CREATE INDEX DATECODE ON dbo.attend(H_CODE)

END