SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BarcodeTbl]( [GoodCode] [int] NOT NULL, [Field1] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Field2] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [SysId] [int] IDENTITY(1,1) NOT NULL, [Quantity] [int] NULL, CONSTRAINT [PK_BarcodeTbl] PRIMARY KEY CLUSTERED ( [SysId] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[BarcodeTbl] WITH CHECK ADD CONSTRAINT [FK_BarcodeTbl_StockTbl] FOREIGN KEY([GoodCode]) REFERENCES [dbo].[StockTbl] ([GoodSyscode]) GO ALTER TABLE [dbo].[BarcodeTbl] CHECK CONSTRAINT [FK_BarcodeTbl_StockTbl]