14. Show tables

14. Show tables

14.1. Synopsis

SHOW TABLE

{ <tables> | <find_expression> } [, ... ]

find_expression ::=
  FIND ( { <tag_expression> | NOT <tag_expression> } [ AND ... ] )

tag_expression ::=
  TAG = 'tag_name'

14.2. Description

SHOW TABLE will show information related to the specified table(s) such as columns and shard size.

14.3. Parameters

entries

The name of the tables for which information should be listed.

find_expression

When your tables are tagged, you can use inline key/value lookups to perform your query over multiple tables. To match all tables that have the tag “stocks”, you can use FIND(tag='stocks' AND type=ts).

14.4. Examples

Show information for the table “sensors”:

SHOW TABLE sensors