invantive documentation
Invantive Support ForumsLog In / Sign Up

PROVIDERSTATS: 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 1
Estimated size (bytes) 2,108

Table Columns

The columns of the table PROVIDERSTATS 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
CATALOG_CNT int64
COLUMN_CNT int64 Number of Rows
COLUMN_DOCUMENTED_CNT int64
COLUMN_SERVER_SIDE_FILTERABLE_CNT int64
RUN_ID guid run_id
SCHEMA_CNT int64
TABLE_CNT int64
TABLE_DELETABLE_CNT int64
TABLE_DESCRIBED_CNT int64
TABLE_DOCUMENTED_CNT int64
TABLE_EXAMPLE_CNT int64
TABLE_INSERTABLE_CNT int64
TABLE_UPDATABLE_CNT int64
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: