You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

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)