SYSTEMTABLECOLUMNS: Data Dictionary Table Columns
read only
- Catalogo:
DataDictionary - Schema:
Invantive - Label: Table Columns
Columns per table.
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella SYSTEMTABLECOLUMNS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
CAN_ |
char |
Può filtrare lato server | Whether the column can be filtered on server-side. | ||
CAN_ |
char |
È possibile filtrare i termini adiacenti lato server | Whether the column can be filtered on server-side using adjacent search terms. | ||
CAN_ |
char |
È possibile filtrare tutti i termini lato server | Whether the column can be filtered on server-side using all search terms. | ||
CAN_ |
char |
È possibile filtrare qualsiasi termine lato server | Whether the column can be filtered on server-side using any search term. | ||
CAN_ |
char |
È possibile filtrare i risultati "contains" lato server | Whether the column can be filtered on server-side using contains text. | ||
CAN_ |
char |
È possibile filtrare i valori uguali lato server | Whether the column can be filtered on server-side using equals. | ||
CAN_ |
char |
È possibile filtrare lato server i valori maggiori di | Whether the column can be filtered on server-side using greater than. | ||
CAN_ |
char |
È possibile filtrare lato server i valori "maggiore o uguale a" | Whether the column can be filtered on server-side using greater than or equal. | ||
CAN_ |
char |
È possibile filtrare lato server i valori inferiori a | Whether the column can be filtered on server-side using less than. | ||
CAN_ |
char |
È possibile filtrare lato server i valori "minore o uguale a" | Whether the column can be filtered on server-side using less than or equal. | ||
CAN_ |
char |
È possibile filtrare i valori "non uguali" lato server | Whether the column can be filtered on server-side using not equals. | ||
CAN_ |
char |
È possibile eseguire la scansione lato server | Whether the column can be scanned on server-side for search terms. | ||
CAN_ |
char |
È possibile eseguire l'ordinamento lato server | Whether the column can be sorted on server-side. | ||
CHECK_ |
char |
Controllare l'ortografia | 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 |
Tipo di dati del database | Data type in the database. | ||
DERIVED_ |
char |
Valore derivato | Whether the column contains a derived value (calculated using an expression). | ||
DISPLAY_ |
varchar2 |
Controllo dello schermo | Display control for displaying the column's contents. | ||
DISPLAY_ |
char |
Visualizzare nel filtro | Whether the column should be included in a search window. | ||
DISPLAY_ |
char |
Visualizzare nella lista dei valori | Whether the column should be included in a pick list. | ||
DISPLAY_ |
char |
Visualizzare in Registrazione | Whether the column should be included in a single record view. | ||
DISPLAY_ |
char |
Visualizzazione nei risultati | Whether the column should be included in a multiple records view. | ||
DISPLAY_ |
int32 |
Lunghezza del display (media) | Average length in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Lunghezza del display (SD) | Standard deviation in characters of the contents of the column. | ||
DISPLAY_ |
int32 |
Visualizzare Ordine | Relative position in which the column should be displayed compared to other columns. | ||
DOCUMENTATION |
varchar2 |
Documentation | Documentation. | ||
DOTNET_ |
varchar2 |
Tipo di dati.NET | Data type for .NET. | ||
EXAMPLE |
varchar2 |
Example | Example. | ||
FETCH_ |
char |
Recupero per impostazione predefinita | 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 |
Inserimento Influenze | Whether the column's value has an impact on the database's contents. | ||
LABEL_ |
varchar2 |
Titolo dell'etichetta | Optional heading label to be shown before the column's normal label. | ||
LABEL_ |
varchar2 |
Etichetta Plurale | Translatable label in plural. | ||
LABEL_ |
varchar2 |
Etichetta Plurale Composto | Translatable label composed of the prefix and the plural label. | ||
LABEL_ |
varchar2 |
Etichetta Plurale Suffisso | Translatable label postfix in plural. | ||
LABEL_ |
varchar2 |
Prefisso dell'etichetta plurale | Translatable label prefix in plural. | ||
LABEL_ |
varchar2 |
Etichetta singolare | Human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Etichetta singolare composta | Translatable label composed of the prefix and the singular label. | ||
LABEL_ |
varchar2 |
Etichetta tradotta al singolare | Translated human-readable label in singular form. | ||
LABEL_ |
varchar2 |
Etichetta Postfisso singolare | Translatable label postfix in singular. | ||
LABEL_ |
varchar2 |
Prefisso dell'etichetta singolare | Translatable label prefix in singular. | ||
MAX_ |
int32 |
Lunghezza Massima | Maximum length. | ||
MINIMUM_ |
int32 |
Lunghezza minima | Minimum required length for a text field. | ||
MINIMUM_ |
varchar2 |
Imbottitura di lunghezza minima | Which side padding has to be applied if the minimum length is not met. | ||
MOST_ |
varchar2 |
Nome non più qualificato | 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 |
Alias del contenitore di dati | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID di contenitore di dati | Data container ID. | ||
PROVIDER_ |
varchar2 |
Descrizione del fornitore | Provider description. | ||
PROVIDER_ |
guid |
UID dell'istanza del provider | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nome del fornitore | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nome abbreviato del fornitore | Provider short name. | ||
SCALE |
int16 |
Scale | Scale. | ||
SOURCE_ |
varchar2 |
Fonte dell'informazioni aggiuntive 1 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Fonte dell'informazioni aggiuntive 2 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Fonte dell'informazioni aggiuntive 3 | Additional information, no predefined structure. | ||
SOURCE_ |
varchar2 |
Percorso di origine | 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 |
Descrizione della tabella | 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 |
Tabella: Nome completo qualificato | 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 |
Nome della tabella | 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 |
Colonne chiave primarie | 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 |
Tipo di tabella | 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 |
Sostituibile dall'utente | Whether the column's value can be changed ever by a human user with sufficient access rights. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLECOLUMNS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLECOLUMNS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: