Columns per table.
Catalog: DataDictionary
Schema: Invantive
Alias: tcn
Label: Table Columns
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 SYSTEMTABLECOLUMNS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
CAN_FILTER_SERVER_SIDE |
boolean |
Can Filter Server-side |
☑ |
Whether the column can be filtered on server-side. |
CHECK_SPELLING |
boolean |
Check Spelling |
☑ |
Whether the column's value should preferably be checked for spelling and grammar errors in a user interface. |
CLIENT_SIDE_CACHEABLE |
boolean |
Table Client-Side Cacheable |
|
Are the contents eligible for caching on the client? |
DATABASE_DATA_TYPE |
string(240) |
Database Data Type |
|
Data type in the database. |
DERIVED_VALUE |
boolean |
Derived Value |
☑ |
Whether the column contains a derived value (calculated using an expression). |
DISPLAY_CONTROL |
string(240) |
Display Control |
☐ |
Display control for displaying the column's contents. |
DISPLAY_IN_FILTER |
boolean |
Display in Filter |
☑ |
Whether the column should be included in a search window. |
DISPLAY_IN_LOV |
boolean |
Display in LOV |
☑ |
Whether the column should be included in a pick list. |
DISPLAY_IN_RECORD |
boolean |
Display in Record |
☑ |
Whether the column should be included in a single record view. |
DISPLAY_IN_RESULTS |
boolean |
Display in Results |
☑ |
Whether the column should be included in a multiple records view. |
DISPLAY_LENGTH_AVERAGE |
int32 |
Display Length (Average) |
☐ |
Average length in characters of the contents of the column. |
DISPLAY_LENGTH_SD |
int32 |
Display Length (SD) |
☐ |
Standard deviation in characters of the contents of the column. |
DISPLAY_ORDER |
int32 |
Display Order |
☐ |
Relative position in which the column should be displayed compared to other columns. |
DOCUMENTATION |
string(4000) |
Documentation |
☐ |
Documentation. |
DOTNET_DATA_TYPE |
string(240) |
.NET Data Type |
|
Data type for .NET. |
EXAMPLE |
string(4000) |
Example |
☐ |
Example. |
FETCH_BY_DEFAULT |
boolean |
Fetch by Default |
☑ |
Whether this field is fetched by default. True if the column is fetched by default, or false if it is being fetched when accessed. |
ID |
int32 |
ID |
|
Unique ID of the column. |
INFLUENCES_INSERT |
boolean |
Influences Insert |
☑ |
Whether the column's value has an impact on the database's contents. |
LABEL_HEADING |
string(240) |
Label Heading |
☐ |
Optional heading label to be shown before the column's normal label. |
LABEL_PLURAL_COMPOSED |
string(4000) |
Label Plural Composed |
☐ |
Translatable label composed of the prefix and the plural label. |
LABEL_PLURAL_POSTFIX |
string(240) |
Label Plural Postfix |
☐ |
Translatable label postfix in plural. |
LABEL_PLURAL_PREFIX |
string(240) |
Label Plural Prefix |
☐ |
Translatable label prefix in plural. |
LABEL_PLURAL |
string(4000) |
Label Plural |
☐ |
Translatable label in plural. |
LABEL_SINGULAR_COMPOSED |
string(4000) |
Label Singular Composed |
☐ |
Translatable label composed of the prefix and the singular label. |
LABEL_SINGULAR_I18N |
string(4000) |
Translated Label Singular |
|
Translated human-readable label in singular form. |
LABEL_SINGULAR_POSTFIX |
string(240) |
Label Singular Postfix |
☐ |
Translatable label postfix in singular. |
LABEL_SINGULAR_PREFIX |
string(240) |
Label Singular Prefix |
☐ |
Translatable label prefix in singular. |
LABEL_SINGULAR |
string(4000) |
Label Singular |
|
Human-readable label in singular form. |
MAX_LENGTH |
int32 |
Maximum Length |
|
Maximum length. |
MINIMUM_LENGTH_PADDING |
string(240) |
Minimum Length Padding |
☑ |
Which side padding has to be applied if the minimum length is not met. |
MINIMUM_LENGTH |
int32 |
Minimum Length |
☑ |
Minimum required length for a text field. |
MOST_UNQUALIFIED_NAME |
string(240) |
Most Unqualified Name |
☑ |
The most unique name ('users' for 'exactonline.crm.users') |
NAME |
string(240) |
Name |
|
Name of the column. |
NULLABLE |
boolean |
Nullable |
|
Whether the value is optional. |
POSITION |
int32 |
Position |
☑ |
Numeric ID of the column. |
PRECISION |
int16 |
Precision |
|
Precision. |
PROVIDER_DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
PROVIDER_DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
PROVIDER_DESCRIPTION |
string(16000) |
Provider Description |
☑ |
Provider description. |
PROVIDER_NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PROVIDER_SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
SCALE |
int16 |
Scale |
|
Scale. |
SOURCE_ADDITIONAL_INFO_1 |
string(4000) |
Source Additional Information 1 |
|
Additional information, no predefined structure. |
SOURCE_ADDITIONAL_INFO_2 |
string(4000) |
Source Additional Information 2 |
|
Additional information, no predefined structure. |
SOURCE_ADDITIONAL_INFO_3 |
string(4000) |
Source Additional Information 3 |
|
Additional information, no predefined structure. |
SOURCE_PATH |
string(4000) |
Source Path |
|
Path of the source of the value. |
TABLE_CALL_SAFE_NAME |
string(240) |
Table Call Safe Name |
|
Name for use within SQL with special characters escaped. |
TABLE_CAN_DELETE |
boolean |
Table Can Delete |
|
Indicator whether you can delete data in this table. |
TABLE_CAN_INSERT |
boolean |
Table Can Insert |
|
Indicator whether you can insert data in this table. |
TABLE_CAN_SELECT |
boolean |
Table Can Select |
|
Indicator whether you can select data in this table. |
TABLE_CAN_UPDATE |
boolean |
Table Can Update |
|
Indicator whether you can update data in this table. |
TABLE_CATALOG_NAME |
string(240) |
Table Catalog |
|
Catalog where the tables are contained in. |
TABLE_CREATION_DATE_UTC |
datetime |
Table Creation Date |
|
Date at which the table was originally created (UTC). |
TABLE_DESCRIPTION |
string(4000) |
Table Description |
|
Description of the contents. |
TABLE_DOCUMENTATION |
string(4000) |
Table Documentation |
|
Documentation of the table or view. |
TABLE_ESTIMATED_NUMBER_OF_ROWS |
int64 |
Table Estimated Number of Rows |
|
Estimated number of rows in this table per partition |
TABLE_ESTIMATED_SIZE_BYTES |
int64 |
Table Estimated Size in Bytes |
|
Estimated size in bytes of this table per partition. |
TABLE_EXAMPLE |
string(4000) |
Table Example |
|
Example of the contents. |
TABLE_FULL_QUALIFIED_NAME |
string(240) |
Table Full Qualified Name |
|
Full qualified name. |
TABLE_FULL_TABLE_SCAN_ROW_RETRIEVAL_TOTAL_CLOCK_TIME_MS |
int32 |
Table Full Table Scan Row Retrieval Total Clock Time (ms) |
|
Total clock time spent retrieving data using full table scans. |
TABLE_FULL_TABLE_SCAN_ROWS_RETRIEVED |
int32 |
Table Rows Retrieved during Full Table Scans |
|
Total number of rows retrieved using full table scans. |
TABLE_FULL_TABLE_SCANS_EXECUTED |
int32 |
Table Number of Full Table Scans Executed |
|
Total number of full table scans executed. |
TABLE_IS_PARTITION_SPECIFIC |
boolean |
Table Is Partition Specific |
|
Indicator whether the contents of this table typically differ per partition. |
TABLE_LABEL_LIST |
string(4000) |
Table Label for List |
|
Label of the table for use in lists. |
TABLE_LABEL_PLURAL |
string(4000) |
Table Label Plural |
|
Label of the table contents in plural form. |
TABLE_LABEL_SINGULAR |
string(4000) |
Table Label Singular |
|
Label of the table contents in singular form. |
TABLE_LAST_UPDATE_DATE_UTC |
datetime |
Table Last Update Date |
|
Date at which the table's structure was last modified (UTC). |
TABLE_MEASURED_AVERAGE_ACCESS_LATENCY_MS |
int32 |
Table Measured Average Access Latency (ms) |
|
Measured Average Access Latency in milliseconds. |
TABLE_NAME |
string(240) |
Table Name |
|
Name of the table or view. |
TABLE_PARAMETERS |
string(4000) |
Parameters |
|
Parameters defined on the table. |
TABLE_POINT_QUERIES_EXECUTED_TOTAL_CLOCK_TIME_MS |
int32 |
Table Total Clock Time Spent Executing Point Queries (ms) |
|
Total clock time spent retrieving data using point queries. |
TABLE_POINT_QUERIES_EXECUTED |
int32 |
Table Number of Point Queries Executed |
|
Number of point queries executed. |
TABLE_PRIMARY_KEY_FIELD |
string(4000) |
Primary Key Columns |
|
Primary key column(s) of the table. |
TABLE_ROWS_WRITE_TOTAL_CLOCK_TIME_MS |
int32 |
Table Total Time Spent Writing Rows (ms) |
|
Total clock time spent writing rows in milliseconds. |
TABLE_ROWS_WRITTEN |
int32 |
Table Number of Rows Written |
|
Number of rows written. |
TABLE_SCHEMA_NAME |
string(240) |
Table Schema |
|
Schema within the catalog where the table is contained in. |
TABLE_SHORT_NAME |
string(240) |
Table Short Name |
|
Typical alias for the table. |
TABLE_STATIC_AVERAGE_ACCESS_LATENCY_MS |
int32 |
Table Static Average Access Latency (ms) |
|
Statically determined average access latency in milliseconds. |
TABLE_STATIC_AVERAGE_FULL_SCAN_ROWS_PER_MINUTE |
int32 |
Table Static Average Rows per Minute on Full Scan |
|
Statically determined average number of rows accessible per minute. |
TABLE_STATIC_AVERAGE_POINT_QUERY_ROWS_PER_MINUTE |
int32 |
Table Static Average Rows per Minute on Point Query |
|
Statically determined average of points queries throughput per minute. |
TABLE_STATIC_AVERAGE_WRITE_ROWS_PER_MINUTE |
int32 |
Table Static Average Rows per Minute Written |
|
Statically determined throughput of written rows per minute. |
TABLE_TYPE |
string(30) |
Table Type |
|
Type, can be either 'view' or 'table'. |
TABLE_VALID |
boolean |
Table Valid |
|
Whether the structure of the table is valid. |
TABLE_WRITES_EXECUTED |
int32 |
Table Number of Writes |
|
Total number of writes executed. |
USER_CHANGEABLE |
boolean |
User Changeable |
☑ |
Whether the column's value can be changed ever by a human user with sufficient access rights. |
17-05-2021 11:57 Version 20.1.419-BETA+3191