Views per active data container.
Catalog: DataDictionary
Schema: Invantive
Alias: viw
Label: Database Views
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view SYSTEMVIEWS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CATALOG |
string |
Catalog |
|
Catalog where the views are contained in. |
DESCRIPTION |
string |
Description |
|
Description. |
ID |
int32 |
ID |
|
Unique ID of the view. |
NAME |
string |
Name |
|
Name of the view. |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
QUERY |
string |
SQL Query |
|
SQL query. |
SCHEMA |
string |
Schema |
|
Schema within the catalog where the view is contained in. |
17-05-2021 11:57 Version 20.1.419-BETA+3191