SYSTEMTABLECOLUMNS: Data Dictionary Table Columns
read only
- Catalogus:
DataDictionary - Schema:
Invantive - Label: Table Columns
Columns per table.
Kan alleen gegevens ophalen.
Tabelkolommen
De kolommen van de tabel SYSTEMTABLECOLUMNS worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CAN_ |
char |
Kan Server-zijde Filteren | Whether the column can be filtered on server-side. | ||
CAN_ |
char |
Kan Server-side Filteren op Aangrenzende Termen | Whether the column can be filtered on server-side using adjacent search terms. | ||
CAN_ |
char |
Kan Server-side Filteren op Alle Termen | Whether the column can be filtered on server-side using all search terms. | ||
CAN_ |
char |
Kan Server-side Filteren op Elke Term | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
Kan Server-side Filteren op Bevat | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
Kan Server-side Filteren op Gelijkheid | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
Kan Server-side Filteren op Groter dan | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
char |
Kan Server-side Filteren op Groter dan of Gelijk aan | Whether the column can be filtered on server-side using greater than or equal. | ||
CAN_ |
char |
Kan Server-side Filteren op Kleiner dan | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
char |
Kan Server-side Filteren op Kleiner dan of Gelijk aan | Whether the column can be filtered on server-side using less than or equal. | ||
CAN_ |
char |
Kan Server-side Filteren op Ongelijk | Whether the column can be filtered on server-side using not equals. | ||
CAN_ |
char |
Kan Server-side Scannen | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
Kan Server-side Sorteren | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Controleer 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 Datatype | Data type in the database. | ||
DERIVED_ |
char |
Afgeleide Waarde | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Weergavecontrol | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Weergeven in Zoekfilter | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Weergeven in Waardenlijst | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Weergeven in Record | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Weergeven in Resultaten | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Weergavelengte (Gemiddeld) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Weergavelengte (SD) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Weergave Volgorde | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
.NET Datatype | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
char |
Standaard Ophalen | 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 |
Beïnvloedt Toevoegen | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Label Kop | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Label Meervoud | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Label Meervoud Samengesteld | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Label Meervoud Achtervoegsel | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Label Meervoud Voorvoegsel | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Label Enkelvoud | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Label Enkelvoud Samengesteld | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Vertaald Label Enkelvoud | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Label Enkelvoud Achtervoegsel | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Label Enkelvoud Voorvoegsel | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Maximum Lengte | Maximum length. | ||
MINIMUM_ |
int32 |
Minimum Lengte | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Minimale Lengte Opvulling | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Meest Ongekwalificeerde Naam | 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 |
Datacontainer Alias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datacontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Provideromschrijving | Provider description. | ||
PROVIDER_ |
guid |
Providerinstantie UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Providernaam | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Provider Korte Naam | Provider short name. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Bron Aanvullende Informatie 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Bron Aanvullende Informatie 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Bron Aanvullende Informatie 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Bronpad | 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 |
Tabel Omschrijving | 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 |
Tabel Volledig Gekwalificeerde Naam | 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 |
Tabelnaam | 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 |
Primaire Sleutelkolommen | 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 |
Tabelsoort | 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 |
Wijzigbaar door Gebruiker | Whether the column's value can be changed ever by a human user with sufficient access rights. |
Toetsen
| Key | Column | Verwijst naar | 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
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: