sinum.sql

这是一个人事管理系统

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