Link Search Menu Expand Document

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.