19. SHOW TABLE#

19.1. Synopsis#

SHOW TABLE

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

find_expression ::=
  FIND (
    { TAG = <tag_value> | NOT TAG = <tag_value>
      | PREFIX = 'prefix' | SUFFIX = 'suffix' | TYPE = TS }
    [ AND ... ] [ , RECURSIVE = { TRUE | FALSE } ]
  )

tag_value ::= { 'text' | $table } [ || ... ]

19.2. Description#

SHOW TABLE returns the schema of each specified table. The result includes the columns, column types, shard size, and time-to-live value. The command supports time-series tables, general tables, and aggregated tables.

19.3. Parameters#

entries: The names of the tables whose schemas QuasarDB returns.
find_expression: Selects multiple tables with a key/value lookup. For more information, refer to key/value lookups.

19.4. Examples#

Show information for the table “sensors”:

SHOW TABLE sensors