Information schema for columns

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

SELECT
  *
FROM
  information_schema.columns;

Columns in information_schema.columns

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

Column Name	Data Type	Description
table_catalog	TEXT	Name of the catalog. Firebolt provides a single default catalog.
table_schema	TEXT	Name of the database containing the table.
table_name	TEXT	Name of the table containing the column.
column_name	TEXT	Name of the column.
is_nullable	TEXT	YES if the column may contain NULL, NO otherwise.
data_type	TEXT	The data type of the column.
is_in_partition_expr	TEXT	YES if the column is included in the table’s PARTITION BY clause, NO otherwise.
is_in_primary_index	TEXT	YES if the column is included in the tables’s PRIMARY INDEX clause, NO otherwise.
character_maximum_length	NULL	Not applicable for Firebolt.
character_octet_length	NULL	Not applicable for Firebolt.
numeric_precision_radix	NULL	Not applicable for Firebolt.
interval_type	NULL	Not applicable for Firebolt.
interval_precision	NULL	Not applicable for Firebolt.
character_set_catalog	NULL	Not applicable for Firebolt.
character_set_schema	NULL	Not applicable for Firebolt.
character_set_name	NULL	Not applicable for Firebolt.
collation_catalog	NULL	Not applicable for Firebolt.
collation_schema	NULL	Not applicable for Firebolt.
collation_name	NULL	Not applicable for Firebolt.
domain_catalog	NULL	Not applicable for Firebolt.
domain_schema	NULL	Not applicable for Firebolt.
domain_name	NULL	Not applicable for Firebolt.
udt_catalog	NULL	Not applicable for Firebolt.
udt_schema	NULL	Not applicable for Firebolt.
udt_name	NULL	Not applicable for Firebolt.
scope_catalog	NULL	Not applicable for Firebolt.
scope_schema	NULL	Not applicable for Firebolt.
scope_name	NULL	Not applicable for Firebolt.
maximum_cardinality	NULL	Not applicable for Firebolt.
dtd_identifier	NULL	Not applicable for Firebolt.
is_self_referencing	NULL	Not applicable for Firebolt.
is_identity	NULL	Not applicable for Firebolt.
identity_generation	NULL	Not applicable for Firebolt.
identity_start	NULL	Not applicable for Firebolt.
identity_increment	NULL	Not applicable for Firebolt.
identity_maximum	NULL	Not applicable for Firebolt.
identity_minimum	NULL	Not applicable for Firebolt.
identity_cycle	NULL	Not applicable for Firebolt.
is_generated	NULL	Not applicable for Firebolt.
generation_expression	NULL	Not applicable for Firebolt.
is_updatable	NULL	Not applicable for Firebolt.