SYSTEMTABLECOLUMNS: Data Dictionary Table Columns
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Table Columns
Columns per table.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMTABLECOLUMNS 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 |
|---|---|---|---|---|---|
CAN_ |
char |
Can Filter Server-side | Whether the column can be filtered on server-side. | ||
CAN_ |
char |
Can Filter Server-side Adjacent Terms | Whether the column can be filtered on server-side using adjacent search terms. | ||
CAN_ |
char |
Can Filter Server-side All Terms | Whether the column can be filtered on server-side using all search terms. | ||
CAN_ |
char |
Can Filter Server-side Any Term | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
Can Filter Server-side Contains | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
Can Filter Server-side Equals | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
Can Filter Server-side Greater than | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
char |
Can Filter Server-side Greater than or Equal | Whether the column can be filtered on server-side using greater than or equal. | ||
CAN_ |
char |
Can Filter Server-side Less than | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
char |
Can Filter Server-side Less than or Equal | Whether the column can be filtered on server-side using less than or equal. | ||
CAN_ |
char |
Can Filter Server-side Not Equals | Whether the column can be filtered on server-side using not equals. | ||
CAN_ |
char |
Can Scan Server-side | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
Can Sort Server-side | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Check Spelling | Whether the column's value should preferably be checked for spelling and grammar errors in a user interface. | ||
CLIENT_ |
char |
Table Client-Side Cacheable | Are the contents eligible for caching on the client? | ||
DATABASE_ |
varchar2 |
Database Data Type | Data type in the database. | ||
DERIVED_ |
char |
Derived Value | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Display Control | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Display in Filter | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Display in LOV | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Display in Record | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Display in Results | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Display Length (Average) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Display Length (SD) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Display Order | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
.NET Data Type | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
char |
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_ |
char |
Influences Insert | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Label Heading | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Label Plural | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Label Plural Composed | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Label Plural Postfix | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Label Plural Prefix | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Label Singular | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Label Singular Composed | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Translated Label Singular | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Label Singular Postfix | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Label Singular Prefix | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Maximum Length | Maximum length. | ||
MINIMUM_ |
int32 |
Minimum Length | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Minimum Length Padding | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Most Unqualified Name | The most unique name ('users' for 'exactonline.crm.users') | ||
NAME |
varchar2 |
Name | Name of the column. | ||
NULLABLE |
char |
Nullable | Whether the value is optional. | ||
POSITION |
int32 |
Position | Numeric ID of the column. | ||
PRECISION |
int16 |
Precision | Precision. | ||
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. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Source Additional Information 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Source Additional Information 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Source Additional Information 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Source Path | Path of the source of the value. | ||
TABLE_ |
varchar2 |
Table Call Safe Name | Name for use within SQL with special characters escaped. | ||
TABLE_ |
char |
Table Can Delete | Indicator whether you can delete data in this table. | ||
TABLE_ |
char |
Table Can Insert | Indicator whether you can insert data in this table. | ||
TABLE_ |
char |
Table Can Select | Indicator whether you can select data in this table. | ||
TABLE_ |
char |
Table Can Update | Indicator whether you can update data in this table. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
datetime |
Table Creation Date | Date at which the table was originally created (UTC). | ||
TABLE_ |
varchar2 |
Table Description | Description of the contents. | ||
TABLE_ |
varchar2 |
Table Documentation | Documentation of the table or view. | ||
TABLE_ |
int64 |
Table Estimated Number of Rows | Estimated number of rows in this table per partition | ||
TABLE_ |
int64 |
Table Estimated Size in Bytes | Estimated size in bytes of this table per partition. | ||
TABLE_ |
varchar2 |
Table Example | Example of the contents. | ||
TABLE_ |
varchar2 |
Table Full Qualified Name | Full qualified name. | ||
TABLE_ |
int32 |
Table Number of Full Table Scans Executed | Total number of full table scans executed. | ||
TABLE_ |
int64 |
Table Rows Retrieved during Full Table Scans | Total number of rows retrieved using full table scans. | ||
TABLE_ |
double |
Table Full Table Scan Row Retrieval Total Clock Time (ms) | Total clock time spent retrieving data using full table scans. | ||
TABLE_ |
char |
Table Is Partition Specific | Indicator whether the contents of this table typically differ per partition. | ||
TABLE_ |
varchar2 |
Table Label for List | Label of the table for use in lists. | ||
TABLE_ |
varchar2 |
Table Label Plural | Label of the table contents in plural form. | ||
TABLE_ |
varchar2 |
Table Label Singular | Label of the table contents in singular form. | ||
TABLE_ |
datetime |
Table Last Update Date | Date at which the table's structure was last modified (UTC). | ||
TABLE_ |
double |
Table Measured Average Access Latency (ms) | Measured Average Access Latency in milliseconds. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table or view. | ||
TABLE_ |
varchar2 |
Parameters | Parameters defined on the table. | ||
TABLE_ |
int32 |
Table Number of Point Queries Executed | Number of point queries executed. | ||
TABLE_ |
double |
Table Total Clock Time Spent Executing Point Queries (ms) | Total clock time spent retrieving data using point queries. | ||
TABLE_ |
varchar2 |
Primary Key Columns | Primary key column(s) of the table. | ||
TABLE_ |
double |
Table Total Time Spent Writing Rows (ms) | Total clock time spent writing rows in milliseconds. | ||
TABLE_ |
int64 |
Table Number of Rows Written | Number of rows written. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
TABLE_ |
varchar2 |
Table Short Name | Typical alias for the table. | ||
TABLE_ |
double |
Table Static Average Access Latency (ms) | Statically determined average access latency in milliseconds. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute on Full Scan | Statically determined average number of rows accessible per minute. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute on Point Query | Statically determined average of points queries throughput per minute. | ||
TABLE_ |
int32 |
Table Static Average Rows per Minute Written | Statically determined throughput of written rows per minute. | ||
TABLE_ |
varchar2 |
Table Type | Type, can be either 'view' or 'table'. | ||
TABLE_ |
char |
Table Valid | Whether the structure of the table is valid. | ||
TABLE_ |
int32 |
Table Number of Writes | Total number of writes executed. | ||
USER_ |
char |
User Changeable | Whether the column's value can be changed ever by a human user with sufficient access rights. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: