What is a drop set?
You take a set until you cannot hold the load, you lighten it at once, and you continue with no rest. Sometimes a second time. It is an end-of-session tool on a safe movement (a machine, dumbbells you can drop). It is not a way to test a 1RM, and not a heavy squat without supports.
How to bound it
Decide before you start how much you will drop and how many times. "Until you cannot anymore" is not an instruction: the last rep still has to be a movement, not a yank. Once per exercise, at the end of the session, is enough to see if you tolerate it. Being sore the next day is not proof it was better.
Common questions
Are a drop set and a descending set the same?
In gyms, yes: you lighten the load and continue. Some coaches keep "descending set" for a drop decided in advance (for example twice 20%), and "drop set" for a drop when you no longer have the load. Ask what the sheet means; the movement is the same.
Which movements should avoid it?
Squat, deadlift, a heavy bench press, and any movement where a missed rep puts you under the bar. A machine or dumbbells you can put down are the place for a drop set. Fatigue arrives at once: plan the drop before you can no longer take the bar apart.