I got through four years at uni without drinking. I still had a great time. However, one surefire way of me having a rubbish time is if I came out with condescending rubbish about my friends who did drink. (Most) people don't have a problem going out and having a good time with someone who doesn't drink (and those that do have a social skills issue) - BUT people do not want to go out and socialise with someone who judges their decisions.
Perhaps I'm picking the OP up wrong, but there are very strong tones of judgement from this thread. Otherwise why start it in the first place (by the way, if someone started a thread saying 'I'm gonna get so smashed in Freshers Week' I'd think that was a moronic thread too). If I've picked you up wrong, and you're not all all judgemental and have absolutely no problem with people choosing to drink, I apologise. But if I haven't, then you will have a pretty crap time at Uni, not because you don't drink but because that judgement will drive potential friends away.
And for the record, people drink for plenty of reasons other than to get smashed. A nice gin and tonic on a summers evening or a nice glass of wine with dinner, for example has nothing to do with getting drunk and everything to do with taste and social interaction. Again, you can well choose that that is not to your taste and to interact socially in different means (I spent many years with orange juice in my wine glass at dinner...)...but again, there's a not so fine line between making a choice for yourself, and having a judgemental view of anyone making an alternative choice.