I'm so sorry to hear about what the doctor said about your foot. What does "completely gone" mean?
Also - please take what he said about your SCS with a big grain of salt. You probably should get a second opinion and wait till that original appointment to get that...Back doctors are notorious about judging other back doctors' work, and he would have found something to comment upon no matter what. If your SCS hadn't been bothering you... please consider dealing with your foot problem first.... wasn't that your first priority?