Outdated Version

You are viewing an older version of this section. View current production version.

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)