No credit card required
Browse credit cards from a variety of issuers to see if there's a better card for you.
TL;DR: No. The 5% discount does not work for pharmacy prescriptions, OTC drugs behind the pharmacy counter, or Target Optical.
From the Target RedCard Websitesee bolded below, edited for length)
5% RedCard™ discount program rules