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 |
---|---|---|---|---|
|
|
No |
Yes |
Catalog containing the view. |
|
|
No |
Yes |
Schema containing the view. |
|
|
No |
Yes |
Name of the relation. |
|
|
Yes |
Yes |
The view text if the user owns the view, |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
No |
Yes |
Always |
|
|
Yes |
Yes |
Always |
Constraints
The following constraints apply to the VIEWS
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the view. |
Foreign key |
|
|
References TABLES. |