Each row represents a table, view, alias, or nickname. Each table or view hierarchy has one additional row representing the hierarchy table or hierarchy view that implements the hierarchy. Catalog tables and views are included.
Column Name | Data Type | Nullable | Updatable | Description |
---|---|---|---|---|
TABSCHEMA | VARCHAR (128) | Schema name of the object. | ||
TABNAME | VARCHAR (128) | Unqualified name of the object. | ||
CARD | BIGINT | Y | Total number of rows in the table; -1 if statistics are not collected. | |
NPAGES | BIGINT | Y | Total number of pages on which the rows of the table exist; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table. | |
MPAGES | BIGINT | Y | Total number of pages for table metadata. Non-zero only for a table that is organized by column; -1 for a view, an alias, or if statistics are not collected; -2 for subtables or hierarchy tables. | |
FPAGES | BIGINT | Y | Total number of pages; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table. | |
OVERFLOW | BIGINT | Y | Total number of overflow records in the table; -1 for a view or alias, or if statistics are not collected; -2 for a subtable or hierarchy table. | |
CLUSTERED | CHAR (1) | Y |
|
|
ACTIVE_BLOCKS | BIGINT | Y | Total number of active blocks in the table, or -1. Applies to multidimensional clustering (MDC) tables or insert time clustering (ITC) tables only. | |
AVGCOMPRESSEDROWSIZE | SMALLINT | Y | Average length (in bytes) of compressed rows in this table; -1 if statistics are not collected. | |
AVGROWCOMPRESSIONRATIO | REAL | Y | For compressed rows in the table, this is the average compression ratio by row; that is, the average uncompressed row length divided by the average compressed row length; -1 if statistics are not collected. | |
AVGROWSIZE | SMALLINT | Average length (in bytes) of both compressed and uncompressed rows in this table; -1 if statistics are not collected. | ||
PCTROWSCOMPRESSED | REAL | Y | Compressed rows as a percentage of the total number of rows in the table; -1 if statistics are not collected. | |
PCTPAGESSAVED | SMALLINT | Y | Approximate percentage of pages saved in a row-organized table as a result of row compression. For a column-organized table, the estimate is based on the number of data pages needed to store the table in uncompressed row organization.-1 if statistics are not collected. | |
PCTEXTENDEDROWS | REAL | Extended rows as a percentage of the total number of rows in the table; -1 if statistics are not collected. |