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. |