There is a table "A" and a table "B" which references with FK to PK of "A". In this case dropping "A" should give an error saying "the pk ... in A referred by an FK ... in B cannot be dropped. First drop FK constraint.".
Right now, it will prompt for a DBA password to drop. Drop progress bar will run and finish but nothing will happen. Tables are still there and no error message is displayed.