if not Exists(SELECT * FROM information_schema.tables where Table_name = 'PrescriptionFormula') begin create table PrescriptionFormula ( ID int primary key, Code int not null, Title nvarchar(500), -- عنوان فارسی فرمول Dom_ID_ValueType int references Domain(ID) not null, -- مبلغ عدد ثابت یا اسکریپتی Price decimal(19,4), Description nvarchar(1000), Script nvarchar(max), IncludedInsurance bit not null default 0, IncludedTax bit not null default 0, Kar_ID_Creator int References Karbar(ID) not null, TarikhSabt int not null, SaatSabt int not null ) end