# 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 | |---|:---:|---|:---:|---| | `CAN_DELETE` | `char` | Can Delete | | Indicator whether you can delete data in this view. | | `CAN_INSERT` | `char` | Can Insert | | Indicator whether you can insert data in this view. | | `CAN_SELECT` | `char` | Can Select | | Indicator whether you can select data in this view. | | `CAN_UPDATE` | `char` | Can Update | | Indicator whether you can update data in this view. | | `CATALOG` | `varchar2` | Catalog | | Catalog where the views are contained in. | | `CLIENT_SIDE_CACHEABLE` | `char` | Table Client-Side Cacheable | | Are the contents eligible for caching on the client? | | `DESCRIPTION` | `varchar2` | Description | | Description. | | `DOCUMENTATION` | `varchar2` | Documentation | | Documentation. | | `EXAMPLE` | `varchar2` | Example | | Example of the contents. | | `ID` | `int32` | ID | | Unique ID of the view. | | `IS_PARTITION_SPECIFIC` | `char` | Is Partition Specific | | Indicator whether the contents of this table typically differ per partition. | | `NAME` | `varchar2` | Name | | Name of the view. | | `PROVIDER_DATA_CONTAINER_ALIAS` | `varchar2(4000)` | Data Container Alias | ☐ | Data container alias. | | `PROVIDER_DATA_CONTAINER_ID` | `varchar2(4000)` | Data Container ID | ☐ | Data container ID. | | `PROVIDER_DESCRIPTION` | `varchar2(16000)` | Provider Description | ☑ | Provider description. | | `PROVIDER_INSTANCE_UID` | `guid` | Provider Instance UID | ☑ | Unique ID of the provider instance. | | `PROVIDER_NAME` | `varchar2(240)` | Provider Name | ☑ | Name of the provider. | | `PROVIDER_SHORT_NAME` | `varchar2(240)` | Provider Short Name | ☑ | Provider short name. | | `QUERY` | `varchar2` | SQL Query | | SQL query defining the view contents. Only available for non-integrated views. | | `SCHEMA` | `varchar2` | Schema | | Schema within the catalog where the view is contained in. | | `STATIC_AVERAGE_ACCESS_LATENCY_MS` | `double` | Static Average Access Latency (ms) | | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | | `STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE` | `int32` | Static Average Rows per Minute on Full Scan | | Average number of rows that fetched per minute on a full table scan, statically configured. | | `STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE` | `int32` | Static Average Rows per Minute on Point Query | | Average number of rows processed per minute on point queries, statically configured. | | `STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE` | `int32` | Static Average Rows per Minute Written | | Average number of rows written per minute, statically configured. | | `TECHNICAL_DOCUMENTATION` | `varchar2` | Technical Documentation | | Technical documentation. |