There are several types of sedation available, and the appropriate option depends on the procedure and your level of anxiety.
Options may include nitrous oxide (laughing gas), oral medication, IV sedation, or general anesthesia.
Many of these options allow you to remain conscious but in a deeply relaxed state, sometimes referred to as "twilight sleep."