Information schema for views
You can use the information_schema.views
view to return information about each view in a database. The view is available for each database and contains one row for each view in the database. You can use a SELECT
query to return information about each view as shown in the example below.
SELECT
*
FROM
information_schema.views;
Columns in information_schema.views
Each row has the following columns with information about each view.
Column Name | Data Type | Description |
---|---|---|
table_catalog | TEXT | The name of the catalog. Firebolt offers a single ‘default’ catalog. |
table_schema | TEXT | The name of the database. |
table_name | TEXT | The name of the view. |
ddl | TEXT | The query statement that defines the view. |
view_definition | TEXT | The query statement that defines the view. |
check_option | NULL | Not applicable for Firebolt. |
is_updatable | NULL | Not applicable for Firebolt. |
insertable_into | NULL | Not applicable for Firebolt. |
created | TIMESTAMPTZ | Time that the view was created. |
last_altered | TIMESTAMPTZ | Time that the view was last changed. |
description | NULL | Not applicable for Firebolt. |