mysql - How to get only tables, not views using SHOW TABLES?

Question

SHOW TABLES gives you tables+views.

How do I retrieve only tables?

question from:https://stackoverflow.com/questions/2908680/how-to-get-only-tables-not-views-using-show-tables

Answer 1

show full tables where Table_Type = 'BASE TABLE'

verbatim.

Or put another way;

show full tables where Table_Type != 'VIEW'

http://dev.mysql.com/doc/refman/5.0/en/show-tables.html