This indicates that you checked the "Don't show this message again" option for a previous confirmation question.
You can go to Configure > Preferences > User Interface / Options, press the "DSA Dialogs" button, and remove the following line:
DropTABLE=N
This will restore the confirmation question when dropping a table.