The COLUMNS_EXTENSIONS  table has these columns: 

## • TABLE_CATALOG 

The name of the catalog to which the table belongs. This value is always def . 

## • TABLE_SCHEMA 

The name of the schema (database) to which the table belongs. 

## • TABLE_NAME 

The name of the table. 

## • COLUMN_NAME 

The name of the column. 

## • ENGINE_ATTRIBUTE 

Column attributes defined for the primary storage engine. Reserved for future use. 

## • SECONDARY_ENGINE_ATTRIBUTE 

Column attributes defined for the secondary storage engine. Reserved for future use. 

## 26.3.10 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table 

The COLUMN_PRIVILEGES  table provides information about column privileges. It takes its values from the mysql.columns_priv  system table. 

The COLUMN_PRIVILEGES  table has these columns: 

## • GRANTEE 

The name of the account to which the privilege is granted, in ’ user_name ’@’ host_name ’  format. 

## • TABLE_CATALOG 

The name of the catalog to which the table containing the column belongs. This value is always def . 

## • TABLE_SCHEMA 

The name of the schema (database) to which the table containing the column belongs. 

## • TABLE_NAME 

The name of the table containing the column. 

## • COLUMN_NAME 

The name of the column. 

## • PRIVILEGE_TYPE 

The privilege granted. The value can be any privilege that can be granted at the column level; see Section 13.7.1.6, “GRANT Statement” . Each row lists a single privilege, so there is one row per column privilege held by the grantee. 

