information_schema.table_constraints.constraint_type

Note:

Type of constraint; one of UNIQUE, PRIMARY KEY, FOREIGN KEY or CHECK.

Note:

Type of constraint; one of UNIQUE, PRIMARY KEY, FOREIGN KEY or CHECK.

Note:

The type of the constraint. The value can be UNIQUE, PRIMARY KEY or FOREIGN KEY. The UNIQUE and PRIMARY KEY information is similar to the execution result of the SHOW INDEX statement.

Note:

Type of the constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE

Note:

Type of the constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE

Note:

Type of constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE.NOT NULL constraints appear as CHECK constraints in this column.

Note:

Type of constraint: CHECK, foreign key, PRIMARY KEY, or UNIQUE.

Note:

Type of constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE.

Note:

Type of constraint: CHECK UNIQUE PRIMARY KEY FOREIGN KEY