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_ |
varchar2 |
Database Data Type | Data type in the database. | ||
DATA_ |
varchar2 |
Data Format | Data format. | ||
DEFAULT_ |
varchar2 |
Default Value | Default value. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
.NET Data Type | Data type for .NET. | ||
ID |
int32 |
ID | Unique ID of the column. | ||
NAME |
varchar2 |
Name | Name of the column. | ||
PRESENCE_ |
char |
Presence Required | Whether the presence of a value is required. | ||
PROVIDER_ |
varchar2 |
Data Container Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Data Container ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provider Description | Provider description. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Short Name | Provider short name. | ||
SORTING_ |
int32 |
Sort Order | Sorting order of the parameter within the table function. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
varchar2 |
Table Full Qualified Name | Full qualified name. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table or view. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
TABLE_ |
varchar2 |
Table Type | Type, can be either 'view' or 'table'. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLEFUNCTIONPARAMETERS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLEFUNCTIONPARAMETERS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFUNCTIONPARAMETERS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFUNCTIONPARAMETERS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFUNCTIONPARAMETERS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: