SQLCE建复合索引
发布时间:2015-06-05 来源:查字典编辑
摘要:CREATETABLE[PT_check3]([FCheckPlan_ID]NVARCHAR(20)NOTNULL,[FBarCode]NV...
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]))