Table Name doesn't show up in DB Viewer treeview, but shows up on Query

Question

I have a database in SQLYog - MySql GUI, which on expanding in the treeview viewer, shows all the existing tables, but if you query ,say
show tables from database_name
It shows a table that isn't in the database treeview. I tried the query
SHOW TABLE STATUS FROM database_name,
and it shows null for all fields associated with the table. I think the table was deleted sometime ago, but hasn't been erased from the database logs or something.
How do I delete this entry, and also, please tell me why this is happening.

looks similar to [this thread](http://stackoverflow.com/questions/7759170/mysql-table-doesnt-exist-but-it-does-or-it-should) — St3an, Mar 22 '16 at 11:50

score 0 · Accepted Answer · answered Mar 22 '16 at 11:50

0

Unless your mysql server suffered a crash, that "table" is probably a view and sqlyog lists it under the views.

Mysql documentation on show tables says:

This statement also lists any views in the database. The FULL modifier is supported such that SHOW FULL TABLES displays a second output column. Values for the second column are BASE TABLE for a table and VIEW for a view.

Mysql documentation on show table status says:

For views, all the fields displayed by SHOW TABLE STATUS are NULL except that Name indicates the view name and Comment says view.

answered Mar 22 '16 at 11:50

Shadow

33,525
10
51
64

Thank you.. That really helped. – Nash829 Mar 22 '16 at 12:14
In this case can you pls mark the answer as accepted to let other viewers of this topic know that the issue has been resolved? – Shadow Mar 22 '16 at 12:19

Table Name doesn't show up in DB Viewer treeview, but shows up on Query

1 Answers1