SYSTEMSCHEMAS: Data Dictionary Schemas |
Schemas per active data container.
Catalog: DataDictionary
Schema: Invantive
Alias: sma
Label: Schemas
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 SYSTEMSCHEMAS 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. |
NAME |
string |
Schema |
|
Schema within the catalog where the tables are contained in. |
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. |
18-10-2024 06:49 Version 24.0.345-PROD+4945