Skip to main content
Returns a table with a row for each table in the current database, with columns containing information for each table as listed below. For more information regarding tables, see information_schema.tables.

Syntax

SHOW TABLES;

Returns

The returned table has the following columns.
Column nameData TypeDescription
table_nameTEXTThe name of the table.
table_typeTEXTThe table’s type, such as BASE TABLE, EXTERNAL VIEW.
column_countBIGINTThe number of columns in the table.
primary_indexTEXTAn ordered array of the column names comprising the primary index definition, if applicable.
schemaTEXTThe text of the SQL statement that created the table.
number_of_rowsTEXTThe number of rows in the table.
size_compressedTEXTThe compressed size of the table in human readable format.
size_uncompressedTEXTThe uncompressed size of the table in human readable format.
compression_ratioDECIMALThe compression ratio (<size_uncompressed>/<size>).
number_of_tabletsINTEGERThe number of tablets that comprise the table.