It's a colonoscopy. It's usually pretty easy. You probably won't remember a thing from the procedure.
The prep can be a little rough. I'm hypoglycemic and have an especially rough time during the liquid diet part. Don't worry about what you ate today, the laxative should clear you out, it's very powerful.