Shows the list of tables in the currently selected database, or in another database if db_name is specified.

SHOW TABLES [{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]

Notes

• db_name is the name of a MemSQL database. If db_name is not specified, then a database must be currently selected (see USE ).
• pattern - SQL LIKE clause
• expr - SQL WHERE clause
• This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).

Example

memsql> SHOW TABLES;
+------------------------------+
| Tables_in_my_MemSQL_database |
+------------------------------+
| t                            |
+------------------------------+

1 row in set (0.00 sec)

Was this Article Helpful?

Thanks For Your Feedback!