foreign_key_checks specifies whether to enable foreign key constraint check for data manipulation language (DML) statements.
| Property | Description |
|---|---|
| Parameter type | Boolean |
| Default value | 1 |
| Value range | * 0: Disable foreign key constraint check. * 1: Enable foreign key constraint check. |
| Effective scope | * Global * Session |
| Involved in serialization | Yes |
Note
This variable takes effect only on DML operations and does not take effect on data definition language (DDL) operations.