Please enable JavaScript to view this site.

Invantive Vision

In this form you can request data on columns in tables and views.Open screen in browser Open Form

Tables Screen

The meaning of the entry fields is:

Type

The table type. ‘Table’ means a physical table, ‘business object view’ represents a business view and ‘reporting view’ represents a reporting view. See also Structure.

Table Name

The name of the table.

Definition

The definition of the data in the table (only available in English).

Example

An example of the data in the table (only available in English).

Short Name

The short name of the table.

Number of Rows

An indication of the number of rows in the table.

Average Size

An indication of the average size in bytes of a row in the table.

Date Last Analysis

The last time at which the statistics were recalculated.

Tablespace

The ‘tablespace’ where the table is stored.

Number of Indexes

The number of indexes in the table.

Size

The total size of the table and the related indexes.

Size Table

The size of the table.

Size Indexes

The size of the indexes belonging to the table.