SHOW TABLES in Riak TS

You can use the SHOW TABLES statement to enumerate the Riak TS tables you have set up. This document will show you how to execute SHOW TABLES in TS.

The SHOW TABLES statement returns a list of tables you’ve created in a single column with one row per table name.

For example:

SHOW TABLES

Returns:

+---------------+------------+
|   Table       |   Status   |
+---------------+------------|
| RandomTable   |   Active   |
| GeoCheckin    |   Active   |
| UpcomingTable | Not Active |
|AnotherTable   |   Active   |
| FinalTable    |   Active   |
+---------------+------------+

You can use SHOW TABLES in riak shell:

riak-shell>show tables;
+---------------+------------+
|   Table       |   Status   |
+---------------+------------|
| RandomTable   |   Active   |
| GeoCheckin    |   Active   |
| UpcomingTable | Not Active |
|AnotherTable   |   Active   |
| FinalTable    |   Active   |
+---------------+------------+

Using TS’s supported clients, a successful SHOW TABLE will return a regular successful query result:

+---------------+------------+
|   Table       |   Status   |
+---------------+------------|
| RandomTable   |   Active   |
| GeoCheckin    |   Active   |
| UpcomingTable | Not Active |
|AnotherTable   |   Active   |
| FinalTable    |   Active   |
+---------------+------------+