if not Exists(SELECT * FROM information_schema.tables where Table_name = 'TaxGoods') begin CREATE TABLE [dbo].[TaxGoods] ( [ID] [int] primary key IDENTITY(1,1) , [Mat_ID] [bigint] references dbo.Matter(ID) NOT NULL, [Code] [nvarchar](100) NOT NULL, [Title] [nvarchar](500) NULL, [Pro_ID_Unit] [int] references dbo.OtherProperties(ID) NOT NULL, [Price] [decimal](19, 4) NOT NULL, [VatPercent] [int] NOT NULL, [Description] [nvarchar](1000) NULL, [Guid] [nvarchar](200) NULL ) end