Michael J. Swart points out a few foibles about the DROP TABLE syntax:
I was looking at the docs for DROP TABLE and I noticed this in the syntax:
[ ,...n ]. I never realized that you can drop more than one table in a statement.
I think that’s great. When dropping tables one at a time. You always had to be careful about order when foreign keys were involved. Alas, you still have to care about order.
That is a shame. Michael also includes a few other places where DROP TABLE could be made better, so check it out.