SHOW TABLES

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 useful?