DICTIONARY.COLUMN STATISTICS

The following table lists the columns that appear in the result table for the DICTIONARY.COLUMN_STATISTICS table.

Note: Null indicates either a null or a missing value.

Note: The first four columns do not appear in the result table.

Column Name	Column Number	Data Type	Description
TABLE_CAT	1	NVARCHAR1	Catalog name
TABLE_SCHEM	2	NVARCHAR	Schema name Null is returned if the schema is not applicable to the data source. If a driver supports schemas for some tables but not for others, such as when the driver retrieves data from different DBMSs, it returns an empty string ("") for those tables that do not have schemas.
TABLE_NAME	3	NVARCHAR1	Table name
COLUMN_NAME	4	NVARCHAR1	Column name The driver returns an empty string for a column that does not have a name.
TYPE	5	unsigned INTEGER1	Type of information being returned: TKTS_COL_STAT indicates a statistic for the columns specified in the CARDINALITY and HISTOGRAM columns.
CARDINALITY	6	unsigned INTEGER	Cardinality of column or column set in table. This is the number of distinct, non-null values in the column or column set. Null is returned if the value is not available from the data source.
NULL_FRAC	7	DOUBLE	Fraction (expressed as a decimal) of the column's entries that are null. If any of the columns in a set of columns is null then that entry is considered null.
MOST_COMMON_VALS	8	NVARCHAR	Contains a value that is common for this column. Null if there are no common values. Null if the number of columns is greater than one.
MOST_COMMON_FREQS	9	DOUBLE	A frequency of the common value returned in MOST_COMMON_VALS. This would likely be the number of occurrences of that particular column value divided by the total number of rows in the table. Null if the number of columns is greater than one.
HISTOGRAM_ENTRY	10	unsigned INTEGER	The entry for the HISTOGRAM_BOUNDS value. Null if the number of columns is greater than one.
HISTOGRAM_BOUNDS	11	NVARCHAR	One entry in a list of values that divide the column's values into groups of approximately equal population. The most common values (returned by MOST_COMMON_VALS ) are omitted from the histogram calculation. No HISTOGRAM_BOUNDS are returned if the column's data type does not have a less than (< ) operator, or if the values returned by MOST_COMMON_VALS account for the entire population of the column. Null if the number of columns is greater than one.
CORRELATION	12	DOUBLE	Statistical correlation between the physical row ordering and the logical ordering of the column values. The values range from -1 to +1. This value is not returned if the column's data type does not have a less than (< ) operator. Null if the number of columns is greater than one.
1Value cannot be a null or missing value