Anxiety when partner drinks

I really struggle with anxiety whenever my partner goes out drinking.

I have never agreed with drugs, and especially now having a baby, it really rubs me the wrong way. He has only done them on occasion, but the thought of it makes me feel physically ill. I have told him how it makes me feel and he says to me he won’t do it….but does. I have caught him out on a couple of occasions now, when he told me he wouldn’t do it, and I found out he had, and he still continued to deny it. (I had seen messages and videos of him actually doing it)

I definitely have some trust issues there from an incident that occurred a few years ago, but I just really really struggle with him saying he won’t do drugs, having almost no faith in him, and then catching him out anyway.

I’m just wondering if anyone else has been in this situation or felt like this?

Am I being overdramatic, and should just let him have fun once in a while?