SYSTEMTABLEFUNCTIONPARAMETERSLIVE: Data Dictionary Live Retrieve Table Function Parameters
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Live Retrieve Table Function Parameters
Live retrieval of the available parameters per table per data container.
Can only retrieve data.
Summary
Availability varies per platform.
Table Columns
The columns of the table SYSTEMTABLEFUNCTIONPARAMETERSLIVE 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 Container Alias | Alias of the data container. | ||
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. | ||
IS_NEW |
char |
Is New | Is the parameter new. | ||
NAME |
varchar2 |
Name | Name of the column. | ||
PRESENCE_ |
char |
Presence Required | Whether the presence of a value is required. | ||
PROVIDER_ |
guid |
Provider Instance UID | Unique ID of the provider instance. | ||
SERVICE_ |
varchar2 |
URL | URL being accessed | ||
SORTING_ |
int32 |
Sort Order | Sorting order of the parameter within the table function. | ||
TABLE_ |
varchar2 |
Table Call Safe Name | Name for use within SQL with special characters escaped. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
char |
Table is New | Is the table new. | ||
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'. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: