Information schema for tables

You can use the information_schema.tables view to return information about each table in a database. The view is available for each database and contains one row for each table in the database. You can use a SELECT query to return information about each table as shown in the example below.

SELECT
  *
FROM
  information_schema.tables;

Columns in information_schema.tables

Each row has the following columns with information about each table.

Column Name	Data Type	Description
table_catalog	TEXT	The name of the database.
table_schema	TEXT	The name of the schema.
table_name	TEXT	The name of the table.
table_type	TEXT	The table’s type, e.g. BASE TABLE, EXTERNAL VIEW.
table_owner	TEXT	The owner of the table, NULL if there is none.
created	TIMESTAMPTZ	Not applicable for Firebolt.
last_altered	TIMESTAMPTZ	Not applicable for Firebolt.
last_altered_by	TEXT	Not applicable for Firebolt.
primary_index	TEXT	An ordered array of the column names comprising the primary index definition, if applicable.
number_of_rows	BIGINT	The number of rows in the table.
compressed_bytes	BIGINT	The compressed size of the table in bytes.
uncompressed_bytes	BIGINT	The uncompressed size of the table in bytes.
compression_ratio	NUMERIC	The compression ratio (<uncompressed_bytes>/<compressed_bytes>).
number_of_tablets	INTEGER	The number of tablets comprising the table.
fragmentation	DECIMAL	Table fragmentation percentage (between 0-100).
type	TEXT	The table’s type.
location_name	TEXT	Not applicable for Firebolt.
ddl	TEXT	The text of the SQL statement that created the table.
self_referencing_column_name	NULL	Not applicable for Firebolt.
reference_generation	NULL	Not applicable for Firebolt.
user_defined_type_catalog	NULL	Not applicable for Firebolt.
user_defined_type_schema	NULL	Not applicable for Firebolt.
user_defined_type_name	NULL	Not applicable for Firebolt.
is_insertable_into	TEXT	YES if the table is insertable, NO otherwise.
is_typed	TEXT	Always NO.
commit_action	NULL	Not applicable for Firebolt.