Menu
SHOW TABLES gives you tables+views.
How do I retrieve only tables?
616
If you specify the keyword ACCOUNT , then the command retrieves records for all schemas in all databases of the current account. If you specify the keyword DATABASE , then: If you specify a <database_name> , then the command retrieves records for all schemas of the specified database.
Views can provide advantages over tables: Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.
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
181
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
