Cannot delete the mySQL table. (Error 1050)

Question

I have a disgusting table that will not be deleted, and it will support updating my community environment :(

I know this table exists. Example...

mysql> 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) 

However, when I try to remove it ...

 mysql> DROP TABLE IF EXISTS uc_order_products_qty_vw; Query OK, 0 rows affected, 1 warning (0.00 sec) 

This does not work, the table is still there, and a warning says that ...

 mysql> show warnings limit 1; +-------+------+------------------------------------------+ | Level | Code | Message | +-------+------+------------------------------------------+ | Note | 1051 | Unknown table 'uc_order_products_qty_vw' | +-------+------+------------------------------------------+ 1 row in set (0.00 sec) 

Feeling overwhelmed.

Answer 1

Judging by the name, it could be a representation. Try using DROP VIEW :

 DROP VIEW uc_order_products_qty_vw 

DROP TABLE does not work for views:

 CREATE VIEW test_vw AS SELECT 1; SELECT * FROM test_vw; -- works DROP TABLE test_vw; -- error: Unknown table 'test_vw' DROP VIEW test_vw; -- works