IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Matter' AND COLUMN_NAME = 'Guid') begin alter table dbo.Matter add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.BargehDetail add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehDetailProperty' AND COLUMN_NAME = 'Guid') begin alter table dbo.BargehDetailProperty add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BargehProperty' AND COLUMN_NAME = 'Guid') begin alter table dbo.BargehProperty add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'GardesheChek' AND COLUMN_NAME = 'Guid') begin alter table dbo.GardesheChek add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ConvertGoodDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.ConvertGoodDetail add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StoreDocumentItem' AND COLUMN_NAME = 'Guid') begin alter table dbo.StoreDocumentItem add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'StoreDocumentAccountItem' AND COLUMN_NAME = 'Guid') begin alter table dbo.StoreDocumentAccountItem add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SupportItem' AND COLUMN_NAME = 'Guid') begin alter table dbo.SupportItem add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SanadDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.SanadDetail add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'VoucherItem' AND COLUMN_NAME = 'Guid') begin alter table dbo.VoucherItem add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PlanningProgramDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.PlanningProgramDetail add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'PrescriptionDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.PrescriptionDetail add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SalaryReceiptItem' AND COLUMN_NAME = 'Guid') begin alter table dbo.SalaryReceiptItem add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND COLUMN_NAME = 'Guid') begin alter table dbo.DaryaftPardakht add [Guid] nvarchar(200) not null default '' end; IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Guid') begin alter table dbo.ProductDetail add [Guid] nvarchar(200) not null default '' end;