SYSTEMTABLECOLUMNS: Data Dictionary Table Columns
read only
- Katalog:
DataDictionary - Schema:
Invantive - Label: Table Columns
Columns per table.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle SYSTEMTABLECOLUMNS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CAN_ |
char |
Kann serverseitig filtern | Whether the column can be filtered on server-side. | ||
CAN_ |
char |
Kann serverseitige benachbarte Begriffe filtern | Whether the column can be filtered on server-side using adjacent search terms. | ||
CAN_ |
char |
Kann alle Begriffe serverseitig filtern | Whether the column can be filtered on server-side using all search terms. | ||
CAN_ |
char |
Kann serverseitig nach beliebigen Begriffen filtern | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
Kann serverseitig nach Enthält filtern | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
Kann serverseitige Gleichheitsvergleiche filtern | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
Kann serverseitig nach Größer als filtern | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
char |
Kann serverseitig nach größer als oder gleich filtern | Whether the column can be filtered on server-side using greater than or equal. | ||
CAN_ |
char |
Kann serverseitig filtern Weniger als | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
char |
Kann serverseitig nach kleiner oder gleich filtern | Whether the column can be filtered on server-side using less than or equal. | ||
CAN_ |
char |
Kann serverseitig nach Nicht gleich filtern | Whether the column can be filtered on server-side using not equals. | ||
CAN_ |
char |
Kann serverseitig scannen | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
Kann serverseitig sortieren | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Rechtschreibprüfung | 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 |
Datenbank Datentyp | Data type in the database. | ||
DERIVED_ |
char |
Abgeleiteter Wert | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Anzeigecontrol | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Anzeige im Filter | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Anzeige in LOV | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Anzeige in Datensatz | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Anzeige in Ergebnissen | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Anzeigelänge (durchschnittlich) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Anzeigelänge (SD) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Anzeigereihenfolge | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
.NET Datentyp | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
char |
Standardmäßig abrufen | 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 |
Einflüsse einfügen | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Label-Überschrift | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Bezeichnung Mehrzahl | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Übersetzte Bezeichnung Zusammengestellt | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Bezeichnung Mehrzahl Hinterschrift | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Bezeichnung Mehrzahl Präfix | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Bezeichnung Singular | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Zusammengestellte Bezeichnung (Einzelform) | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Übersetzte Bezeichnung (Einzelform) | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Bezeichnung Einzelform Hinterschrift | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Bezeichnung Einzahl Präfix | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Maximale Länge | Maximum length. | ||
MINIMUM_ |
int32 |
Mindestlänge | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Mindestlänge der Auffüllung | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Der unpassendste 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 |
Datencontaineralias | Data container alias. | ||
PROVIDER_ |
varchar2 |
Datenkontainer ID | Data container ID. | ||
PROVIDER_ |
varchar2 |
Treiberbeschreibung | Provider description. | ||
PROVIDER_ |
guid |
Treiber Instanz-UID | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Anbietername | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Treiber Kurzname | Provider short name. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Quelle Zusätzliche Informationen 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Quelle Zusätzliche Informationen 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Quelle Zusätzliche Informationen 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Quellpfad | 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 |
Tabelle Beschreibung | 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 |
Vollständiger Name der Tabelle | 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 |
Tabelle 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 |
Primärschlüsselspalten | 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 |
Tabellentyp | 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 |
Benutzer Änderbar | Whether the column's value can be changed ever by a human user with sufficient access rights. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: