
IF EXISTS( 
SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'publ_LandlordPortfolio' AND COLUMN_NAME = 'LandlordPortfolio_LandlordPortfolio_Property'
AND DATA_TYPE = 'int')
BEGIN
    ALTER TABLE publ_LandlordPortfolio 
    ALTER COLUMN LandlordPortfolio_LandlordPortfolio_Property NVARCHAR(MAX) NULL;
END


IF EXISTS( 
SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'publ_Inspections' AND COLUMN_NAME = 'Inspection_Schedule_InspectionNumber'
AND DATA_TYPE = 'int')
BEGIN
    ALTER TABLE publ_Inspections 
    ALTER COLUMN Inspection_Schedule_InspectionNumber NVARCHAR(MAX) NULL;
END