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. Ifdb_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)