SYSTEMTABLES: Data Dictionary Tables
read only
- Catálogo:
DataDictionary - Esquema:
Invantive - Label: Tables
Tables, function tables and views per active data container.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMTABLES. 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 |
|---|---|---|---|---|---|
CACHE_ |
char |
Resultado de la memoria caché | Whether the result of the execution can be cached for the lifetime of the statement. | ||
CALL_ |
varchar2 |
Llamar un Nombre Seguro | Name for use within SQL with special characters escaped. | ||
CAN_ |
char |
Se puede eliminar | Indicator whether you can delete data in this table. | ||
CAN_ |
char |
Se puede insertar | Indicator whether you can insert data in this table. | ||
CAN_ |
char |
Se puede seleccionar | Indicator whether you can select data in this table. | ||
CAN_ |
char |
Se puede actualizar | Indicator whether you can update data in this table. | ||
CATALOG |
varchar2 |
Catalog | Catalog where the tables are contained in. | ||
CLIENT_ |
char |
Se puede almacenar en caché en el lado del cliente | Are the contents eligible for caching on the client? | ||
CREATION_ |
datetime |
Fecha de Creación | Date at which the table was originally created (UTC). | ||
DESCRIPTION |
varchar2 |
Description | Description of the contents. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
EDI_ |
varchar2 |
Nombre de clase EDI | EDI: master class name. | ||
EDI_ |
varchar2 |
Ruta EDI desde el maestro | EDI: path from the master instance. | ||
ESTIMATED_ |
int64 |
Número Estimado de Filas | Estimated number of rows in this table per partition. | ||
ESTIMATED_ |
int64 |
Tamaño estimado en bytes | Estimated size in bytes of this table per partition. | ||
EXAMPLE |
varchar2 |
Example | Example of the contents. | ||
FULL_ |
varchar2 |
Nombre completo y cualificado | Fully qualified name. | ||
FULL_ |
double |
Tiempo transcurrido de escaneos completos (ms) | Time elapsed during full scans (ms). | ||
FULL_ |
int32 |
Análisis completos ejecutados | Number of full scans executed. | ||
FULL_ |
int64 |
Escaneo completo (filas) | Number of full scans row processed. | ||
ID |
int32 |
ID | Unique ID of the table. | ||
IS_ |
char |
Es específico de la Partición | Indicator whether the contents of this table typically differ per partition. | ||
LABEL_ |
varchar2 |
Etiqueta por Lista | Label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Lista de etiquetas traducidas | Translated label of the table for use in lists. | ||
LABEL_ |
varchar2 |
Etiquetas Plurales | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Etiqueta traducida en plural | Label of the table contents in plural form. | ||
LABEL_ |
varchar2 |
Etiquetas Singulares | Label of the table contents in singular form. | ||
LABEL_ |
varchar2 |
Etiqueta traducida en singular | Translated label of the table contents in singular form. | ||
LAST_ |
datetime |
Fecha de la Última Actualización | Date at which the table's structure was last modified (UTC). | ||
MEASURED_ |
double |
Latencia de acceso promedio medida (ms) | Measured average round-trip latency in milliseconds (across cloud: network latency + disks + reception, on SCSI: disks) statically configured. | ||
MEASURED_ |
int32 |
Número promedio medido (fila de escaneo completa por minuto) | Measured average number of rows that fetched per minute on a full table scan. | ||
MEASURED_ |
int32 |
Número medio medido de filas de consulta de puntos por minuto | Measured average number of rows processed per minute on point queries. | ||
MEASURED_ |
int32 |
Número medio medido de filas escritas por minuto | Measured average number of rows written per minute. | ||
NAME |
varchar2 |
Name | Name of the table or view. | ||
ODATA_ |
varchar2 |
Ruta de base de OData | OData: base path. | ||
ODATA_ |
varchar2 |
Método de selección de campos de OData | OData: field selection method. | ||
ODATA_ |
varchar2 |
URL de metadatos de OData | OData: URL for retrieving metadata. | ||
ODATA_ |
varchar2 |
Filtros OData del lado del servidor | OData: text representation of server-side filters. | ||
ODATA_ |
varchar2 |
URL del servicio OData para eliminar | OData: service URL for deleting data. | ||
ODATA_ |
varchar2 |
URL del servicio OData para insertar | OData: service URL for inserting data. | ||
ODATA_ |
varchar2 |
URL del servicio OData para Select | OData: service URL for retrieving data. | ||
ODATA_ |
varchar2 |
URL del servicio OData para la actualización | OData: service URL for updating data. | ||
POINT_ |
double |
Tiempo empleado en consultas puntuales (ms) | Time elapsed during point queries (ms). | ||
POINT_ |
int32 |
Consultas de filas a puntos | Number of point queries executed. | ||
PRIMARY_ |
varchar2 |
Columnas de clave principal | Primary key column(s) of the table. | ||
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. | ||
SCHEMA |
varchar2 |
Schema | Schema within the catalog where the table is contained in. | ||
SHORT_ |
varchar2 |
Nombre Corto | Typical alias for the table. | ||
SOAP_ |
varchar2 |
Acción SOAP | SOAP: action. | ||
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. | ||
SWAGGER_ |
varchar2 |
Tipo de contenido Swagger | SWAGGER: content type. | ||
SWAGGER_ |
varchar2 |
Operación de eliminación de Swagger | SWAGGER: delete operation. | ||
SWAGGER_ |
varchar2 |
Operación de inserción Swagger | SWAGGER: insert operation. | ||
SWAGGER_ |
varchar2 |
Nombre de la tabla de mapeo previo de Swagger | SWAGGER: pre-mapping table name. | ||
SWAGGER_ |
varchar2 |
Esquema de respuesta de Swagger | SWAGGER: response schema. | ||
SWAGGER_ |
varchar2 |
Operación de selección de Swagger | SWAGGER: select operation. | ||
SWAGGER_ |
varchar2 |
Operación de actualización de Swagger | SWAGGER: update operation. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TECHNICAL_ |
varchar2 |
Documentación técnica | Technical documentation. | ||
TYPE |
varchar2 |
Type | Type, can be either 'view' or 'table'. | ||
VALID |
char |
Valid | Whether the structure of the table is valid. | ||
WEBHOOK_ |
varchar2 |
Columna clave Webhook | Key column on webhook messages. | ||
WEBHOOK_ |
varchar2 |
Topic | Webhook topic. | ||
WRITES_ |
int32 |
Escrituras ejecutadas | Number of writes executed. | ||
WRITE_ |
double |
Tiempo de escritura transcurrido (ms) | Time elapsed during point queries (ms). | ||
WRITTEN_ |
int64 |
Filas escritas | Number of rows written. | ||
XML_ |
varchar2 |
XPath básico | XML: XPath expression which forms the root containing all rows. | ||
XML_ |
varchar2 |
Prefijo de espacio de nombres predeterminado | XML: default namespace prefix. | ||
XML_ |
varchar2 |
Tipo complejo con nombre | XML: name of the complex type. | ||
XML_ |
varchar2 |
Filtros del lado del servidor | XML: text representation of server-side filters. | ||
XML_ |
varchar2 |
URL del servicio | XML: Service URL. | ||
XML_ |
varchar2 |
Topic | XML: topic or action as known on the remote server.Defaults to Name when not set. | ||
XML_ |
varchar2 |
XPath | XML: XPath expression for the data when specified or the root otherwise.The XPath typically does NOT include the base XPath. |
Teclas
| Key | Column | Se refiere a | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
CATALOG |
SYSTEMSCHEMAS. |
Key | |
SYSTEMTABLES_ |
SCHEMA |
SYSTEMSCHEMAS.NAME |
Key | |
SYSTEMTABLES_ |
PROVIDER_ |
SYSTEMPROVIDERS.NAME |
Key |
Referenciado por
- SYSTEMTABLECOLUMNS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLECOLUMNS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLECOLUMNS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLECOLUMNS
TABLE_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEFOREIGNKEYS
TABLE_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEFUNCTIONPARAMETERS
TABLE_NAME(Key) - SYSTEMTABLEKEYS
PROVIDER_INSTANCE_UID(Key) - SYSTEMTABLEKEYS
TABLE_CATALOG_NAME(Key) - SYSTEMTABLEKEYS
TABLE_SCHEMA_NAME(Key) - SYSTEMTABLEKEYS
TABLE_NAME(Key) - SYSTEMVIEWS
PROVIDER_INSTANCE_UID(Key) - SYSTEMVIEWS
CATALOG(Key) - SYSTEMVIEWS
SCHEMA(Key) - SYSTEMVIEWS
NAME(Key)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: