Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 42.4Mb
PDF (A4) - 42.5Mb
Man Pages (TGZ) - 271.6Kb
Man Pages (Zip) - 382.9Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb
Excerpts from this Manual

23.6.16.36 The ndbinfo foreign_keys Table

The foreign_keys table provides information about foreign keys on NDB tables. This table has the following columns:

  • object_id

    The foreign key's object ID

  • name

    Name of the foreign key

  • parent_table

    The name of the foreign key's parent table

  • parent_columns

    A comma-delimited list of parent columns

  • child_table

    The name of the child table

  • child_columns

    A comma-separated list of child columns

  • parent_index

    Name of the parent index

  • child_index

    Name of the child index

  • on_update_action

    The ON UPDATE action specified for the foreign key; one of No Action, Restrict, Cascade, Set Null, or Set Default

  • on_delete_action

    The ON DELETE action specified for the foreign key; one of No Action, Restrict, Cascade, Set Null, or Set Default

The foreign_keys table was added in NDB 8.0.29.