invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SYSTEMTABLECOLUMNSLIVE: Data Dictionary Live Retrieved Table Columns

read only

  • Catálogo: DataDictionary
  • Esquema: Invantive
  • Label: Live Retrieved Table Columns

Live retrieval of the available columns per table per data container.

Solo puede recuperar datos.

Resumen

Availability varies per platform.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SYSTEMTABLECOLUMNSLIVE. 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
CLIENT_SIDE_CACHEABLE char Table Client-Side Cacheable Are the contents eligible for caching on the client?
DATABASE_DATA_TYPE varchar2 Tipo de Datos de la Base de Datos Data type in the database.
DATA_CONTAINER_ALIAS varchar2(240) Alias del Contenedor de Datos Alias of the data container.
DOCUMENTATION varchar2 Documentation Documentation.
DOTNET_DATA_TYPE varchar2 Tipo de Datos .NET Data type for .NET.
GET_VALUE varchar2 Obtener el Valor Function used for post-processing.
ID int32 ID Unique ID of the column.
IS_NEW char Es nuevo Is the field new.
LABEL_SINGULAR varchar2 Etiquetas Singulares Human-readable label in singular form.
MAX_LENGTH int64 Longitud Máxima Maximum length.
NAME varchar2 Name Name of the column.
NULLABLE char Nullable Whether the value is optional.
POST_PROCESS_GET_VALUE varchar2 Postproceso Obtener Valor Whether the value is completed by Invantive after processing.
PRECISION int64 Precision Precision.
PROVIDER_INSTANCE_UID guid UID de instancia de proveedor Unique ID of the provider instance.
SCALE int64 Scale Scale.
SERVICE_URL varchar2 URL URL being accessed
TABLE_CALL_SAFE_NAME varchar2 Table Call Safe Name Name for use within SQL with special characters escaped.
TABLE_CAN_DELETE char Table Can Delete Indicator whether you can delete data in this table.
TABLE_CAN_INSERT char Table Can Insert Indicator whether you can insert data in this table.
TABLE_CAN_SELECT char Table Can Select Indicator whether you can select data in this table.
TABLE_CAN_UPDATE char Table Can Update Indicator whether you can update data in this table.
TABLE_CATALOG_NAME varchar2 Table Catalog Catalog where the tables are contained in.
TABLE_CREATION_DATE_UTC datetime Table Creation Date Date at which the table was originally created (UTC).
TABLE_DESCRIPTION varchar2 DEscripción de la Tabla Description of the contents.
TABLE_DOCUMENTATION varchar2 Table Documentation Documentation of the table or view.
TABLE_ESTIMATED_NUMBER_OF_ROWS int64 Table Estimated Number of Rows Estimated number of rows in this table per partition
TABLE_ESTIMATED_SIZE_BYTES int64 Table Estimated Size in Bytes Estimated size in bytes of this table per partition.
TABLE_EXAMPLE varchar2 Table Example Example of the contents.
TABLE_IS_NEW char La tabla es nueva Is the table new.
TABLE_IS_PARTITION_SPECIFIC char Table Is Partition Specific Indicator whether the contents of this table typically differ per partition.
TABLE_LABEL_LIST varchar2 Table Label for List Label of the table for use in lists.
TABLE_LABEL_PLURAL varchar2 Table Label Plural Label of the table contents in plural form.
TABLE_LABEL_SINGULAR varchar2 Table Label Singular Label of the table contents in singular form.
TABLE_LAST_UPDATE_DATE_UTC datetime Table Last Update Date Date at which the table's structure was last modified (UTC).
TABLE_NAME varchar2 Nombre de la Tabla Name of the table or view.
TABLE_PRIMARY_KEY_FIELD varchar2 Table Primary Key The primary key field of the table.
TABLE_SCHEMA_NAME varchar2 Table Schema Schema within the catalog where the table is contained in.
TABLE_SHORT_NAME varchar2 Table Short Name Typical alias for the table.
TABLE_TYPE varchar2 Tipo de tabla Type, can be either 'view' or 'table'.
TABLE_VALID char Table Valid Whether the structure of the table is valid.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: