if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Partner') begin create table dbo.[Partner] ( ID int primary key identity(1,1), Code int not null, Mat_ID bigint references Matter(ID) not null, FC_ID int references Finance_Cycle(ID) not null, Pro_ID_VahedMali int references OtherProperties(ID) not null, Dom_ID_RowType int references Domain(ID) not null, Taf_ID bigint references Tafsili(ID) not null, Quantity decimal(19,4) not null, Price decimal(19,4) not null, ProfitRate decimal(19,4) null, [Description] nvarchar(1000), [Guid] nvarchar(200) not null ) end