PROVIDERTABLECOLUMNS: In-Memory
insert update delete
- Catalog: ``
- Primary Keys:
rowid$
Can retrieve data and change data using insert, update and delete.
Performance Characteristics
| Characteristic | Value |
|---|---|
| Estimated rows | 0 |
| Estimated size (bytes) | 2,856 |
Table Columns
The columns of the table PROVIDERTABLECOLUMNS 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. | ||
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). | ||
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. | ||
LABEL_ |
varchar2 |
Label Singular | Human-readable label in singular form. | ||
MAX_ |
int32 |
Maximum Length | Maximum length. | ||
NAME |
varchar2 |
Name | Name of the column. | ||
NULLABLE |
char |
Nullable | Whether the value is optional. | ||
PRECISION |
int16 |
Precision | Precision. | ||
RUN_ID |
guid |
run_id |
|||
SCALE |
int16 |
Scale | Scale. | ||
SERVER_ |
varchar2 |
server_ |
|||
SOURCE_ |
varchar2 |
Source Path | Path of the source of the value. | ||
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_ |
varchar2 |
Table Full Qualified Name | Full qualified name. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table or view. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
USER_ |
char |
User Changeable | Whether the column's value can be changed ever by a human user with sufficient access rights. | ||
rowid$ |
number |
Row ID | computed | Artificial primary key of an in-memory table. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: