View In Use and Will Not DROP - MySQL29 Jun 2013 I had several views in my MySQL database that were showing "In Use" and phpmyadmin would not let me drop them through the interface.The solution:Open the MySQL in terminal and "DROP VIEW yourView;"