SHOW keyword

This keyword provides column and table information including metadata such as hysteresis parameters. The SHOW keyword is useful for checking if tables contain a designated timestamp column.

info

These commands return the tables and columns as a table. If you would like to query your tables and columns with filters or to use the results as part of a function, see table_columns() and tables() functions.

Examples#

Show all tables:

SHOW TABLES;
table
weather
my_table
...

Show all columns for table my_table

SHOW COLUMNS FROM my_table;
columntypeindexedindexBlockCapacitysymbolCachedsymbolCapacitydesignated
symbSYMBOLtrue1048576false256false
priceDOUBLEfalse0false0false
tsTIMESTAMPfalse0false0true
sSTRINGfalse0false0false