MySQL :: MySQL 8.0 Reference Manual :: 25.8 The INFORMATION_SCHEMA COLUMN

MySQL 8.0 Reference Manual / INFORMATION_SCHEMA Tables / The INFORMATION_SCHEMA COLUMN_STATISTICS Table

25.8 The INFORMATION_SCHEMA COLUMN_STATISTICS Table

The COLUMN_STATISTICS table provides access to histogram statistics for column values.

You can see information only for columns for which you have some privilege.

The COLUMN_STATISTICS table has these columns:

SCHEMA_NAME
The names of the schema for which the statistics apply.
TABLE_NAME
The names of the column for which the statistics apply.
COLUMN_NAME
The names of the column for which the statistics apply.
HISTOGRAM
A JSON object describing the column statistics, stored as a histogram.

PREV HOME UP NEXT