## • IS_MANDATORY 

YES  or NO , depending on whether the role is mandatory. 

## 26.3.4 The INFORMATION_SCHEMA CHARACTER_SETS Table 

The CHARACTER_SETS  table provides information about available character sets. 

## Notes 

The CHARACTER_SETS  table has these columns: 

## • CHARACTER_SET_NAME 

The character set name. 

## • DEFAULT_COLLATE_NAME 

The default collation for the character set. 

## • DESCRIPTION 

A description of the character set. 

## • MAXLEN 

The maximum number of bytes required to store one character. 

Character set information is also available from the SHOW CHARACTER SET  statement. See Section 13.7.7.3, “SHOW CHARACTER SET Statement” . The following statements are equivalent: 

SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE CHARACTER_SET_NAME LIKE ’ wild ’] SHOW CHARACTER SET [LIKE ’ wild ’] 

## 26.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table 

As of MySQL 8.0.16, CREATE TABLE  permits the core features of table and column CHECK  constraints, and the the CHECK_CONSTRAINTS  table provides information about these constraints. 

The CHECK_CONSTRAINTS  table has these columns: 

## • CONSTRAINT_CATALOG 

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

## • CONSTRAINT_SCHEMA 

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

## • CONSTRAINT_NAME 

The name of the constraint. 

## • CHECK_CLAUSE 

The expression that specifies the constraint condition. 

## 26.3.6 The INFORMATION_SCHEMA COLLATIONS Table 

