Lots of people I know have colonoscopies. They're fine - you're not under general anesthesia or anything, just tranquilized. Some of the prep involves drinking a laxative in a powder form mixed with water, but some drs. have you drink like gallons of some liquid. Ask for the former!
It will be fine. Nobody gets sick from it or anything.
Take care.