Our 2.5 year old was not scared at all and even had some fun on the indoor slide in the waiting area.
Pointer to parents - prepare your kids before their first visit. Show them videos/cartoons of first visits to dentists, so they know what to expect.