Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION SCHEMA JSON_DUALITY_VIEW_LINKS Table

28.3.20 The INFORMATION SCHEMA JSON_DUALITY_VIEW_LINKS Table

TheJSON_DUALITY_VIEW_LINKS table shows information about the relationships between parent and child tables for all views accessible by the current user. There is one row per view.

TheJSON_DUALITY_VIEW_LINKS table has the columns shown here:

  • TABLE_CATALOG

    View catalog; this is alwaysdef.

  • TABLE_SCHEMA

    View schema.

  • TABLE_NAME

    View name.

  • PARENT_TABLE_CATALOG

    Parent catalog; this is alwaysdef.

  • PARENT_TABLE_SCHEMA

    Parent schema.

  • PARENT_TABLE_NAME

    Parent table.

  • CHILD_TABLE_CATALOG

    Child catalog; this is alwaysdef.

  • CHILD_TABLE_SCHEMA

    Child schema.

  • CHILD_TABLE_NAME

    Child table.

  • PARENT_TABLE_COLUMN_NAME

    Parent column name.

  • CHILD_TABLE_COLUMN_NAME

    Child column name.

  • JOIN_TYPE

    One ofNESTED orOUTER.

  • JSON_KEY_NAME

    Name of the applicable JSON key, if any.

TheJSON_DUALITY_VIEW_LINKS table was added in MySQL 9.4.0