SYSTEMVIEWS: Data Dictionary Database Views |
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 UniversalSQL 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.
View Columns
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_INSTANCE_UID |
guid |
Provider Instance UID |
☑ |
Unique ID of the provider instance. |
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 defining the view contents. Only available for non-integrated views. |
SCHEMA |
string |
Schema |
|
Schema within the catalog where the view is contained in. |
18-10-2024 06:49 Version 24.0.345-PROD+4945