Link Search Menu Expand Document

SHOW TABLES

Returns a table with a row for each table in the current database, with columns containing information for each table as listed below.

Syntax

SHOW TABLES;

Returns

The returned table has the following columns.

Column name Data Type Description
table_name STRING The name of the table.
state STRING The current table state.
table_type STRING One of FACT, DIMENSION, or EXTERNAL.
column_count INT The number of columns in the table.
primary_index STRING An ordered array of the column names comprising the primary index definition, if applicable.
schema STRING The text of the SQL statement that created the table.
number_of_rows INT The number of rows in the table.
size DOUBLE The compressed size of the table.
size_uncompressed DOUBLE The uncompressed size of the table.
compression_ratio DOUBLE The compression ratio (<size_uncompressed>/<size>).
number_of_segments INT The number of segments comprising the table.