How does alcohol affect your music producing creative abilities?

I have some fun memories (and shitty songs) from drunk music making with friends. When getting drunk enough I notice i cant even remember some guitar riffs at all.
Now im 30 and 1 strong beer makes me feel drunk, and sometimes sad so there’s less drinking now lol. Though I have had 1 beer when writing this.
Creativity-wise it doesn’t really add or remove anything for me.