In the output from SHOW FULL COLUMNS , the privileges are all in one column and in lowercase, for example, select,insert,update,references . In COLUMN_PRIVILEGES , there is one privilege per row, in uppercase. 

• IS_GRANTABLE 

YES  if the user has the GRANT OPTION  privilege, NO  otherwise. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE=’GRANT OPTION’ . 

## Notes 

• COLUMN_PRIVILEGES  is a nonstandard INFORMATION_SCHEMA  table. 

The following statements are not  equivalent: 

SELECT ... FROM INFORMATION_SCHEMA.COLUMN_PRIVILEGES SHOW GRANTS ... 

## 26.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table 

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

For information about histogram statistics, see Section 8.9.6, “Optimizer Statistics” , and Section 13.7.3.1, “ANALYZE TABLE Statement” . 

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. 

## 26.3.12 The INFORMATION_SCHEMA ENABLED_ROLES Table 

The ENABLED_ROLES  table (available as of MySQL 8.0.19) provides information about the roles that are enabled within the current session. 

The ENABLED_ROLES  table has these columns: 

## • ROLE_NAME 

The user name part of the granted role. 

• ROLE_HOST 

