Tables in MSSQL cannot be deleted

If you attempt to delete certain ELO Sync tables in Microsoft SQL Server, SQL Server returns an error:

Warning

Could not drop object 'dbo.elosync_synccollections' because it is referenced by a FOREIGN KEY constraint. (Microsoft SQL Server, Error: 3726)

Solution

Remove the foreign key constraint for provider_id in the table elosync_synccollections.

You should be able to delete all tables after you have removed the foreign key constraint.