Child pages
  • Internal Use Tables

This document presents the tables of internal and exclusive use of the system.


TOTVS | DBAccess has a set of tables for internal use.
These tables define the behavior of the entire system and the rules on how to use the data and tables created through it in the relational database in use.

TOTVS | DBAccess exclusively handles this set of tables.
Handling its content directly may cause system instability and/or occasional error in the system and in TOTVS | DBAccess. 

The TOTVS | DBAccess internal use tables are:

Table

Description

TOP_FIELD

Contains structure information on system tables.

TOP_IDXSTATS

When the monitoring of TOTVS | DBAccess indices is enabled, it contains information on the use of indices of system tables.

TOP_PARAM

Contains referential integrity information of system tables (if enabled), and one or more dynamic records created by the Microsiga Protheus ERP.

TOP_SP

Contains information on Stored Procedures applied in SGDB by the Microsiga Protheus ERP.

TOP_VIRTUALIDX

Contains information on virtualized indices, when used.

TOTVS reserves the right to change this structure and the handling of its content, if needed, without prior notice.

  • No labels