content_image/705318.jpg
<img src='content_image/705318.jpg'>

The TABLE_CONSTRAINTS_EXTENSIONS  table has these columns: 

• CONSTRAINT_CATALOG 

The name of the catalog to which the table belongs. 

• CONSTRAINT_SCHEMA 

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

• CONSTRAINT_NAME 

The name of the constraint. 

• TABLE_NAME 

The name of the table. 

• ENGINE_ATTRIBUTE 

## Note 

The TABLE_CONSTRAINTS_EXTENSIONS  table is reserved for future use. 

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

• SECONDARY_ENGINE_ATTRIBUTE 

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

## 26.3.44 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table 

The TABLE_PRIVILEGES  table provides information about table privileges. It takes its values from the mysql.tables_priv  system table. 

The TABLE_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 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. 

• PRIVILEGE_TYPE 

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

