OleDbSchemaGuid.Table_Statistics Field

Definition

Describes the available set of statistics on tables in the provider.

public: static initonly Guid Table_Statistics;
public static readonly Guid Table_Statistics;
 staticval mutable Table_Statistics : Guid
Public Shared ReadOnly Table_Statistics As Guid 

Field Value

Remarks

Table_Statistics maps to the OLE DB TABLE_STATISTICS rowset. Unless otherwise specified, restriction columns are returned in the following order.

Restriction column CLR data type Description
TABLE_CATALOG string Catalog name of the table of this statistic. A null value if the provider does not support catalogs.
TABLE_SCHEMA string Schema name of the table. A null value if the provider does not support schemas.
TABLE_NAME string Table name.
STATISTICS_CATALOG string Catalog name of the statistic. A null value if the provider does not support catalogs.
STATISTICS_SCHEMA string Schema name of the statistic. A null value if the provider does not support schemas.
STATISTICS_NAME string Name of the statistic.
STATISTICS_TYPE UInt16 (Int32) Bitmask specifying the kinds of statistics supported by this statistic:

DBSTAT_HISTOGRAM - Indicates histogram support.

DBSTAT_COLUMN_CARDINALITY - Indicates column cardinality support.

DBSTAT_TUPLE_CARDINALITY - Indicates tuple cardinality support.

Note: Histograms correspond to only the first column for a multi-column statistic.

Applies to