Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.2Kb
Man Pages (Zip) - 402.4Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.6.16.36 The ndbinfo foreign_keys Table

Theforeign_keys table provides information about foreign keys onNDB 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

    TheON UPDATE action specified for the foreign key; one ofNo Action,Restrict,Cascade,Set Null, orSet Default

  • on_delete_action

    TheON DELETE action specified for the foreign key; one ofNo Action,Restrict,Cascade,Set Null, orSet Default

Theforeign_keys table was added in NDB 8.0.29.