How to destroy sphere collision component on weapon attached to the character when i pick up the weapon

Something like this?

I’ve tried to do it like you said and I move it in differents places but the result is always the same, it only destroy the one is on the floor.