4.30 to 4.40 upgrade error

Hello

I'm getting a sql error when upgrading from 4.30 to 4.40. I started with 3.10 and ran all the sql scripts up to and including 4.30. The site starts and runs. However when upgrading to 4.40 I get:

The error was The object 'FK_dbo.RewardPointsHistory_dbo.Order_UsedWithOrder_Id' is dependent on column 'UsedWithOrder_Id'.
      ALTER TABLE DROP COLUMN UsedWithOrder_Id failed because one or more objects access this column.

       ---> System.Data.SqlClient.SqlException (0x80131904): The object 'FK_dbo.RewardPointsHistory_dbo.Order_UsedWithOrder_Id' is dependent on column 'UsedWithOrder_Id'.
      ALTER TABLE DROP COLUMN UsedWithOrder_Id failed because one or more objects access this column.

Any ideas what may be causing this how to resolve?

Thanks
Sean

Looks like in previous versions there was a Foreign Key
RewardPointsHistory_UsedWithOrder
It is not in the later versions
Maybe there should have been some code to delete it ?
I just search google so I dont realy know - but you could try running script

ALTER TABLE RewardPointsHistory DROP CONSTRAINT RewardPointsHistory_UsedWithOrder

Then retry the Upgrade

Thanks, I'll give that a go.

Yep that work. Cheers!