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.Documentation Index
Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
Use this file to discover all available pages before exploring further.
Syntax
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. |