invantive documentation
Invantive SupportforenAnmelden / Eintragen

SYSTEMTABLEFOREIGNKEYS: Data Dictionary Foreign Keys

read only

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: Foreign Keys

Foreign keys per table per data container, one row per column of a foreign key.

Es können nur Daten abgerufen werden.

Zusammenfassung

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

Tabellenspalten

Die Spalten der Tabelle SYSTEMTABLEFOREIGNKEYS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
COLUMN_NAME varchar2(240) Spalte Name Name of the column.
COLUMN_POSITION int32 Spalte 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_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.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Datencontaineralias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datenkontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Treiberbeschreibung Provider description.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Anbietername Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Treiber Kurzname Provider short name.
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 Referenztabelle Name of the table referred to.
REFERENCED_TABLE_SCHEMA_NAME varchar2 Reference Schema Schema of the table referred to, when known.
TABLE_CATALOG_NAME varchar2 Table Catalog Catalog where the tables are contained in.
TABLE_FULL_QUALIFIED_NAME varchar2(240) Vollständiger Name der Tabelle Full qualified name.
TABLE_NAME varchar2 Tabelle 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 Tabellentyp Type, can be either 'view' or 'table'.

Tasten

Key Column Bezieht sich auf Kind Description
SYSTEMTABLEFOREIGNKEYS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEFOREIGNKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk PROVIDER_INSTANCE_UID SYSTEMTABLES.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEFOREIGNKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_CATALOG_NAME SYSTEMTABLES.CATALOG Key
SYSTEMTABLEFOREIGNKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_SCHEMA_NAME SYSTEMTABLES.SCHEMA Key
SYSTEMTABLEFOREIGNKEYS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_NAME SYSTEMTABLES.NAME Key

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: