invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMTABLEKEYS: Data Dictionary Table Keys

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Table Keys

Primary and unique keys per table per data container, one row per column of a key.

Can only retrieve data.

Summary

Lists the keys the driver knows of the tables it has loaded the metadata of. The guarantee tells whether the engine may trust a key to leave out a join: 'Declared' keys are shown but not relied upon.

Table Columns

The columns of the table SYSTEMTABLEKEYS 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.
ID int32 ID Unique ID of the row.
KEY_COLUMN_COUNT int32 Columns Number of columns of the 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_NAME varchar2(240) Key Name Name of the key, when known.
KEY_TYPE varchar2(30) Key Type Type of the key: 'primary' or 'unique'.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
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.
TABLE_TYPE varchar2 Table Type Type, can be either 'view' or 'table'.

Keys

Key Column Refers to Kind Description
SYSTEMTABLEKEYS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk PROVIDER_INSTANCE_UID SYSTEMTABLES.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_CATALOG_NAME SYSTEMTABLES.CATALOG Key
SYSTEMTABLEKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_SCHEMA_NAME SYSTEMTABLES.SCHEMA Key
SYSTEMTABLEKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_NAME SYSTEMTABLES.NAME Key

Release Notes

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