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. For more information regarding tables, see information_schema.tables.

Syntax

SHOW TABLES;

Returns

The returned table has the following columns.

Column name	Data Type	Description
table_name	TEXT	The name of the table.
table_type	TEXT	The table’s type, such as `BASE TABLE`, `EXTERNAL` `VIEW`.
column_count	BIGINT	The number of columns in the table.
primary_index	TEXT	An ordered array of the column names comprising the primary index definition, if applicable.
schema	TEXT	The text of the SQL statement that created the table.
number_of_rows	TEXT	The number of rows in the table.
size_compressed	TEXT	The compressed size of the table in human readable format.
size_uncompressed	TEXT	The uncompressed size of the table in human readable format.
compression_ratio	DECIMAL	The compression ratio (`<size_uncompressed>`/`<size>`).
number_of_tablets	INTEGER	The number of tablets that comprise the table.

SHOW INDEXES

SHOW VIEWS

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Returns

​Syntax

​Returns

Syntax

Returns