IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Tarikh') begin alter table dbo.ProductDetail ALTER COLUMN Tarikh int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'CodeKarbar') begin alter table dbo.ProductDetail ALTER COLUMN CodeKarbar int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'TarikhSabt') begin alter table dbo.ProductDetail ALTER COLUMN TarikhSabt int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'SaatSabt') begin alter table dbo.ProductDetail ALTER COLUMN SaatSabt smallint null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Pro_ID') begin alter table dbo.ProductDetail ALTER COLUMN Pro_ID int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Saat') begin alter table dbo.ProductDetail ALTER COLUMN Saat int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'FC_ID') begin alter table dbo.ProductDetail ALTER COLUMN FC_ID int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND COLUMN_NAME = 'Pro_ID_VahedMali') begin alter table dbo.ProductDetail ALTER COLUMN Pro_ID_VahedMali int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Product' AND COLUMN_NAME = 'CodeKarbar') begin alter table dbo.Product ALTER COLUMN CodeKarbar int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Product' AND COLUMN_NAME = 'TarikhSabt') begin alter table dbo.Product ALTER COLUMN TarikhSabt int null end; IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Product' AND COLUMN_NAME = 'SaatSabt') begin alter table dbo.Product ALTER COLUMN SaatSabt smallint null end;