title: Can't delete a mySQL table. (Error 1050)
body: <p>I have a pesky table that will not delete and it's holding up my dev environment refresh :(</p>
  
  <p>I know this table exists. Example...</p>
  
  <pre><code>mysql&gt; select * from uc_order_products_qty_vw limit 10;
  +-----+-------------+---------+---------+---------+---------+
  | nid | order_count | avg_qty | sum_qty | max_qty | min_qty |
  +-----+-------------+---------+---------+---------+---------+
  | 105 |           1 |  1.0000 |       1 |       1 |       1 | 
  | 110 |           5 |  1.0000 |       5 |       1 |       1 | 
  | 111 |           1 |  1.0000 |       1 |       1 |       1 | 
  | 113 |           5 |  1.0000 |       5 |       1 |       1 | 
  | 114 |           1 |  1.0000 |       1 |       1 |       1 | 
  | 115 |           1 |  1.0000 |       1 |       1 |       1 | 
  | 117 |           2 |  1.0000 |       2 |       1 |       1 | 
  | 119 |           3 |  1.3333 |       4 |       2 |       1 | 
  | 190 |           5 |  1.0000 |       5 |       1 |       1 | 
  | 199 |           2 |  1.0000 |       2 |       1 |       1 | 
  +-----+-------------+---------+---------+---------+---------+
  10 rows in set (0.00 sec)
  </code></pre>
  
  <p>However when I try to drop it...</p>
  
  <pre><code>mysql&gt; DROP TABLE IF EXISTS uc_order_products_qty_vw;
  Query OK, 0 rows affected, 1 warning (0.00 sec)
  </code></pre>
  
  <p>It doesn't work, the table is still there, and the warning says this...</p>
  
  <pre><code>mysql&gt; show warnings limit 1;
  +-------+------+------------------------------------------+
  | Level | Code | Message                                  |
  +-------+------+------------------------------------------+
  | Note  | 1051 | Unknown table 'uc_order_products_qty_vw' | 
  +-------+------+------------------------------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Feeling pretty dumbfounded.</p>