No.The popular conception is like that though.Rcently I had watched an interview with a Saudi’s executioner and he said that as far as beheading is concerned no drug is administered (Anesthesia).But for other punishments such as chopping limbs or other parts ,it is used.
