复合索引【SQLCE建复合索引】

CREATE TABLE [PT_check3] ( [FCheckPlan_ID] NVARCHAR(20) NOT NULL , [FBarCode] NVARCHAR(20) NOT NULL, [FIn_Code] NVARCHAR(10) NOT NULL , [FGoodsName] NVARCHAR(30) NOT NULL , [FIsReCheck] INT NULL , [FQty] Numeric(10, 2) NULL , CONSTRAINT [PK_vw_Checks] UNIQUE ([FCheckPlan_ID],[FIn_Code]))