I let my cashiers have drinks with them, but it has to be a closed water bottle, rather than water cups from Food Ave. It's been a non-issue in our store. But everyone is pretty understanding if we have a visit or something.
Technically speaking, while I know we have to do what our policies say, when it comes to ACTUAL general health code, like outside of Target, I'm pretty sure you can have drinks with you as long as it's a closed container, with the exception of food prep areas. I don't work in a Super Target, so we don't even have food prep areas. So the "no drink" rule sounds more like a special Target rule.
It seems to be more of a "I'm pretending I don't see this" but you better fucking throw it away later or else.