drop view t1, t2, ... and drop table t1, t2, ... silently ignores arguments past the first

[alamb]

Describe the bug
drop view t1, t2, ... and drop table t1, t2, ... silently ignores arguments past the first

To Reproduce

❯ create view foo as select 1;
0 rows in set. Query took 0.020 seconds.
❯ create view bar as select 1;
0 rows in set. Query took 0.000 seconds.
❯ drop view foo, bar;
0 rows in set. Query took 0.000 seconds.
❯ select * from foo;
Plan("table 'datafusion.public.foo' not found")
❯ select * from bar;
+----------+
| Int64(1) |
+----------+
| 1        |
+----------+

Expected behavior
The drop statement should fail

Additional context
Found while working on #4513