if not Exists(SELECT * FROM information_schema.tables where Table_name = 'BillingItem') begin create table dbo.BillingItem ( ID int primary key identity(1,1), Bil_ID int references dbo.Billing(ID) not null, Dom_ID_RowType int references dbo.Domain(ID) not null, CI_ID int references dbo.ContractItem(ID) null, Kal_ID int references dbo.Kala(ID) null, Taf_ID bigint references dbo.Tafsili(ID) null, Title nvarchar(500) null, Quantity float not null, QuantityConfirm float not null, Price decimal(19,4) not null, PriceConfirm decimal(19,4) not null, [Description] nvarchar(1000) null, [Guid] nvarchar(200) null ) end