invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERTABLECOLUMNS: In-Memory

insert update delete

  • Catalog: ``
  • Primary Keys: rowid$

Can retrieve data and change data using insert, update and delete.

Performance Characteristics

Characteristic Value
Estimated rows 0
Estimated size (bytes) 2,856

Table Columns

The columns of the table PROVIDERTABLECOLUMNS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CAN_FILTER_SERVER_SIDE char Can Filter Server-side Whether the column can be filtered on server-side.
DATABASE_DATA_TYPE varchar2(240) Database Data Type Data type in the database.
DERIVED_VALUE char Derived Value Whether the column contains a derived value (calculated using an expression).
DOCUMENTATION varchar2(4000) Documentation Documentation.
DOTNET_DATA_TYPE varchar2(240) .NET Data Type Data type for .NET.
EXAMPLE varchar2(4000) Example Example.
FETCH_BY_DEFAULT char Fetch by Default Whether this field is fetched by default. True if the column is fetched by default, or false if it is being fetched when accessed.
LABEL_SINGULAR varchar2(4000) Label Singular Human-readable label in singular form.
MAX_LENGTH int32 Maximum Length Maximum length.
NAME varchar2(240) Name Name of the column.
NULLABLE char Nullable Whether the value is optional.
PRECISION int16 Precision Precision.
RUN_ID guid run_id
SCALE int16 Scale Scale.
SERVER_SIDE_CAPABILITIES varchar2 server_side_capabilities
SOURCE_PATH varchar2(4000) Source Path Path of the source of the value.
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(240) Table Catalog Catalog where the tables are contained in.
TABLE_FULL_QUALIFIED_NAME varchar2(240) Table Full Qualified Name Full qualified name.
TABLE_NAME varchar2(240) Table Name Name of the table or view.
TABLE_SCHEMA_NAME varchar2(240) Table Schema Schema within the catalog where the table is contained in.
USER_CHANGEABLE char User Changeable Whether the column's value can be changed ever by a human user with sufficient access rights.
rowid$ number Row ID computed Artificial primary key of an in-memory table.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: