Share via

STATISTICS Rowset

  • Article

GUID: DBSCHEMA_STATISTICS

Number of restriction columns: 3

Restriction columns: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

Default sort order: TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME

Description: The STATISTICS rowset identifies the statistics defined in the catalog that are owned by a given user.

Note

This table is not related to the TABLE_STATISTICS rowset.

Column name

Type indicator

Description

TABLE_CATALOG

DBTYPE_WSTR

Catalog name. NULL if the provider does not support catalogs.

TABLE_SCHEMA

DBTYPE_WSTR

Unqualified schema name. NULL if the provider does not support schemas.

TABLE_NAME

DBTYPE_WSTR

Table name.

CARDINALITY

DBTYPE_UI8

Cardinality (number of rows) of the table.