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

Syntax

SHOW [FULL] [Temporary] TABLES [{FROM | IN} db_name]
[[EXTENDED] LIKE pattern | WHERE TABLE_TYPE {= | !=} {'VIEW' | 'BASE_TABLE'}]

Remarks

• 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
• If you specify a table type, you must also use the FULL keyword
• 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!