Some places ASK for your SSN but don't require you show the physical card. Doctor/dentist office is one place that asks for it (probably to verify insurance coverage), but have never asked me to show the actual SS card.
You can always say no. I have never given my or my kids SSN to doctors, schools, etc and it's never been a problem. I just leave the space blank and not once has anyone cared.