Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


25.6.15.37 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