SYSTEMTABLEFUNCTIONPARAMETERSLIVE: Data Dictionary Live Retrieve Table Function Parameters |
Contents Previous Home Next More |
Live retrieval of the available parameters per table per data container.
Catalog: DataDictionary
Schema: Invantive
Alias: tfe
Label: Live Retrieve Table Function Parameters
Documentation:
Availability varies per platform.
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
The columns of the view SYSTEMTABLEFUNCTIONPARAMETERSLIVE are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
DATA_CONTAINER_ALIAS |
string(240) |
Data Container Alias |
☐ |
Alias of the data container. |
DATABASE_DATA_TYPE |
string |
Database Data Type |
|
Data type in the database. |
DEFAULT_VALUE |
string |
Default Value |
☐ |
Default value. |
DOCUMENTATION |
string |
Documentation |
|
Documentation. |
DOTNET_DATA_TYPE |
string |
.NET Data Type |
|
Data type for .NET. |
ID |
int32 |
ID |
|
Unique ID of the column. |
IS_NEW |
boolean |
Is New |
|
Is the parameter new. |
NAME |
string |
Name |
|
Name of the column. |
PRESENCE_REQUIRED |
boolean |
Presence Required |
|
Whether the presence of a value is required. |
SERVICE_URL |
string |
URL |
|
URL being accessed |
SORTING_ORDER |
int32 |
Sort Order |
|
Sorting order of the parameter within the table function. |
TABLE_CALL_SAFE_NAME |
string |
Table Call Safe Name |
|
Name for use within SQL with special characters escaped. |
TABLE_CATALOG_NAME |
string |
Table Catalog |
|
Catalog where the tables are contained in. |
TABLE_IS_NEW |
boolean |
Table is New |
|
Is the table new. |
TABLE_NAME |
string |
Table Name |
|
Name of the table or view. |
TABLE_SCHEMA_NAME |
string |
Table Schema |
|
Schema within the catalog where the table is contained in. |
TABLE_TYPE |
string |
Table Type |
|
Type, can be either 'view' or 'table'. |
17-05-2021 11:57 Version 20.1.419-BETA+3191