VIEWS

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only

INFORMATION_SCHEMA.VIEWS describes view specific information about views in the catalog.

The rows returned are limited to the views the user is privileged to interact with.

Definition

The VIEWS relation contains the following columns:

Name	Data type	Nullable	Standard	Description
TABLE_CATALOG	STRING	No	Yes	Catalog containing the view.
TABLE_SCHEMA	STRING	No	Yes	Schema containing the view.
TABLE_NAME	STRING	No	Yes	Name of the relation.
VIEW_DEFINITION	STRING	Yes	Yes	The view text if the user owns the view, NULL otherwise.
CHECK_OPTION	STRING	No	Yes	Always 'NONE'. Reserved for future use.
IS_UPDATABLE	STRING	No	Yes	Always NO. Reserved for future use
IS_INSERTABLE_INTO	STRING	No	Yes	Always NO. Reserved for future use.
SQL_PATH	STRING	Yes	Yes	Always NULL. Reserved for future use.

Name	Data type	Nullable	Standard	Description
TABLE_CATALOG	STRING	No	Yes	Catalog containing the view.
TABLE_SCHEMA	STRING	No	Yes	Schema containing the view.
TABLE_NAME	STRING	No	Yes	Name of the relation.
VIEW_DEFINITION	STRING	Yes	Yes	The view text if the user owns the view, NULL otherwise.
CHECK_OPTION	STRING	No	Yes	Always 'NONE'. Reserved for future use.
IS_UPDATABLE	STRING	No	Yes	Always NO. Reserved for future use
IS_INSERTABLE_INTO	STRING	No	Yes	Always NO. Reserved for future use.
SQL_PATH	STRING	Yes	Yes	Always NULL. Reserved for future use.

Constraints

The following constraints apply to the VIEWS relation:

Class	Name	Column List	Description
Primary key	VIEWS_PK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME	Unique identifier for the view.
Foreign key	VIEWS_TABLES_FK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME	References TABLES.

Class	Name	Column List	Description
Primary key	VIEWS_PK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME	Unique identifier for the view.
Foreign key	VIEWS_TABLES_FK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME	References TABLES.

Examples

SQL

> SELECT is_intertable_into
    FROM information_schema.views
    WHERE table_schema = 'information_schema'
      AND table_name = 'columns'
  NO

Related

• DESCRIBE TABLE
• Information schema
• INFORMATION_SCHEMA.COLUMNS
• INFORMATION_SCHEMA.SCHEMATA
• INFORMATION_SCHEMA.TABLES
• INFORMATION_SCHEMA.TABLE_PRIVILEGES
• SHOW CREATE TABLE
• SHOW VIEWS