sinum.sql

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

CREATE TABLE dbo.sinum
(
   SN_MAX NUMERIC(7,2) NULL,
   SN_MIN NUMERIC(7,2) NULL,
   SN_ITEM VARCHAR(10) NULL,
   SN_KIND VARCHAR(4) NULL,
   SN_CODE VARCHAR(3) NULL
)

GO

CREATE INDEX SN_KIND ON dbo.sinum(SN_KIND)

GO

CREATE INDEX SN_ITEM ON dbo.sinum(SN_ITEM)

GO

CREATE INDEX SN_CODE ON dbo.sinum(SN_CODE)

END