foreign_key_checks

Description

foreign_key_checks specifies whether to enable FOREIGN KEY constraint check for DML or DDL statements.

Attributes

Considerations

Foreign key constraint check is enabled in OceanBase Database by default. This check is controlled by the tenant variable foreign_key_checks. When you create a foreign key constraint without specifying a name, the system automatically allocates a constraint name with the table name, _OBFK_, and creation timestamp. For example, t1_OBFK_1627747200000000.

Examples

• Session level

  obclient> SET foreign_key_checks = ON;
  

  or

  obclient> SET foreign_key_checks = 1;
  

• Global level

  obclient> SET GLOBAL foreign_key_checks = ON;
  

  or

  obclient> SET GLOBAL foreign_key_checks = 1;
  

References

• FOREIGN KEY constraints
• Define column constraints