IF EXISTS(
    SELECT * FROM sys.columns 
    WHERE Name      = N'allocatedReference'
      AND Object_ID = Object_ID(N'pal_Account'))
BEGIN
    ALTER TABLE dbo.pal_Account 
	ALTER COLUMN allocatedReference nvarchar(max) NULL;
END
