invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMTABLEFUNCTIONPARAMETERS: Data Dictionary Table Function Parameters

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Table Function Parameters

Parameters per table per data container.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMTABLEFUNCTIONPARAMETERS 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
DATABASE_DATA_TYPE varchar2 Database Data Type Data type in the database.
DATA_FORMAT varchar2(60) Data Format Data format.
DEFAULT_VALUE varchar2 Default Value Default value.
DOCUMENTATION varchar2 Documentation Documentation.
DOTNET_DATA_TYPE varchar2 .NET Data Type Data type for .NET.
ID int32 ID Unique ID of the column.
NAME varchar2 Name Name of the column.
PRESENCE_REQUIRED char Presence Required Whether the presence of a value is required.
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.
SORTING_ORDER int32 Sort Order Sorting order of the parameter within the table function.
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
SYSTEMTABLEFUNCTIONPARAMETERS_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_fk PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEFUNCTIONPARAMETERS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk PROVIDER_INSTANCE_UID SYSTEMTABLES.PROVIDER_INSTANCE_UID Key
SYSTEMTABLEFUNCTIONPARAMETERS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_CATALOG_NAME SYSTEMTABLES.CATALOG Key
SYSTEMTABLEFUNCTIONPARAMETERS_PROVIDER_INSTANCE_UID_SYSTEMTABLES_fk TABLE_SCHEMA_NAME SYSTEMTABLES.SCHEMA Key
SYSTEMTABLEFUNCTIONPARAMETERS_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: