Why drinking is prohibited in Islam?

I have this doubt since a long time. Some of my friends said that it (drink) will affect your mind and your body. This may be correct when we drink a large amount of drink. Even if we drink a very small amount of drink it will not affect our mind and scientists say that which is good for our health. So small amount of drink is allowed? Or else what is the correct reason behind this?