CODEWITHSUNDEEP
mysqlphpmyadminmysql-workbench
Gravy
Gravy

Reputation: 12445

visible table does not exist in phpmyadmin

In mysqlworkbench, I created a view, committed it to the database, but I no longer needed it. As such, I deleted the view in mysql workbench and then updated the database.

I thought all was fine, however in phpmyadmin, it says that the table still exists. What's more, it is constantly in use.

I tried to drop the table within phpmyadmin, however when I try to drop the table, it provides an error message saying:

1051 - Unknown table ... indicating to me that the table is not there.

but it still remains showing in the database, and under collation, it says that the table is 'in use'.

Any advice here?

Upvotes: 2

Views: 1696

Answers (1)

Gravy
Gravy

Reputation: 12445

Problem solved.

It appears as though you cannot delete a view from the database by normal means. The following solved the problem for me.

DROP VIEW IF EXISTS viewName;

Upvotes: 1

Related Questions