invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERTABLEFOREIGNKEYS: 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) 1,956

Table Columns

The columns of the table PROVIDERTABLEFOREIGNKEYS 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
COLUMN_NAME varchar2(240) Column Name Name of the column.
COLUMN_POSITION int32 Column Position Position of the column within the key, starting at 1.
KEY_COLUMN_COUNT int32 Columns Number of columns of the key.
KEY_DESCRIPTION varchar2(4000) Description When the relation holds or what it was found on, in words; always filled for a textual or candidate foreign key.
KEY_GUARANTEE varchar2(60) Key Status What holds the key: 'Declared' (not relied upon), 'Enforced' or 'EnforcedIgnoringTrailingBlanks' (enforced, comparing texts without their trailing blanks).
KEY_KIND varchar2(30) Key Type Kind of the foreign key: 'Key' (the columns refer to a key of the table referred to), 'Textual' (described in words only, such as a polymorphic reference or a row that may have moved to an archive) or 'Candidate' (follows from the names and holds in the data, but is not stated by the platform).
KEY_NAME varchar2(240) Key Name Name of the key, when known.
REFERENCED_COLUMN_NAME varchar2(240) Reference Column Name Name of the column referred to, at the same position in the key referred to.
REFERENCED_TABLE_NAME varchar2 Reference Table Name of the table referred to.
REFERENCED_TABLE_SCHEMA_NAME varchar2 referenced_table_schema_name
RUN_ID guid run_id
TABLE_CATALOG_NAME varchar2 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 Table Name Name of the table or view.
TABLE_SCHEMA_NAME varchar2 Table Schema Schema within the catalog where the table is contained in.
referenced_table_catalog_name varchar2 Table Catalog referenced_table_catalog_name Catalog where the tables are contained in.
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: