Given the problems it causes due the the irresponsibility of the stupid few, I'm all for banning consumption of alcohol on flights. I enjoy a glass of wine or a shot of whisky as much as anyone else, but I can do without it.
And drinking your own on board is just a no-no for so many reasons, mostly already stated here.