Ah! I was fooled by your user name!
Yes, there are different ways of sedating, and for colonoscopies they just need you relaxed and probably a little 'under'. As I wrote, I don't remember anything at all.
I'm sure you'll be fine. Just make sure you follow the 'cleaning out' procedure the day before.