SYSTEMVIEWS: Data Dictionary Database Views
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: Database Views
Views per active data container.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMVIEWS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CAN_ |
char |
Se puede eliminar | Indicator whether you can delete data in this view. | ||
CAN_ |
char |
Se puede insertar | Indicator whether you can insert data in this view. | ||
CAN_ |
char |
Se puede seleccionar | Indicator whether you can select data in this view. | ||
CAN_ |
char |
Se puede actualizar | Indicator whether you can update data in this view. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the views are contained in. | ||
CLIENT_ |
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_ |
char |
Es específico de la Partición | Indicator whether the contents of this table typically differ per partition. | ||
NAME |
varchar2 |
Name | Name of the view. | ||
PROVIDER_ |
varchar2 |
Alias del Contenedor de Datos | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID del Contenedor de Datos | Data container ID. | ||
PROVIDER_ |
varchar2 |
Descripción del proveedor | Provider description. | ||
PROVIDER_ |
guid |
UID de instancia de proveedor | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nombre del Proveedor | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nombre abreviado del proveedor | Provider short name. | ||
QUERY |
varchar2 |
Consulta SQL | 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_ |
double |
Latencia de Acceso Media Estática (ms) | Technical average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
STATIC_ |
int32 |
Filas Estáticas Medias por Minuto en Examen Completo. | Average number of rows that fetched per minute on a full table scan, statically configured. | ||
STATIC_ |
int32 |
Filas Estáticas Medias por Minuto en Consulta sobre Punto | Average number of rows processed per minute on point queries, statically configured. | ||
STATIC_ |
int32 |
Filas Estáticas Medias Escritas por Minuto | Average number of rows written per minute, statically configured. | ||
TECHNICAL_ |
varchar2 |
Documentación técnica | Technical documentation. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMVIEWS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMVIEWS_ |
PROVIDER_ |
SYSTEMSCHEMAS. |
Key | |
SYSTEMVIEWS_ |
CATALOG |
SYSTEMSCHEMAS. |
Key | |
SYSTEMVIEWS_ |
SCHEMA |
SYSTEMSCHEMAS.NAME |
Key | |
SYSTEMVIEWS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMVIEWS_ |
CATALOG |
SYSTEMTABLES. |
Key | |
SYSTEMVIEWS_ |
SCHEMA |
SYSTEMTABLES. |
Key | |
SYSTEMVIEWS_ |
NAME |
SYSTEMTABLES.NAME |
Key |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: