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_TABLES Table

28.3.21 The INFORMATION SCHEMA JSON_DUALITY_VIEW_TABLES Table

TheJSON_DUALITY_VIEW_TABLES table shows information about all tables referenced by any JSON duality view which is accessible by the current user. This table contains one row per table reference.

TheJSON_DUALITY_VIEW_TABLES table has the columns listed here:

  • TABLE_CATALOG

    View catalog; this is alwaysdef.

  • TABLE_SCHEMA

    View schema.

  • TABLE_NAME

    View name.

  • REFERENCED_TABLE_CATALOG

    Table catalog; this is alwaysdef.

  • REFERENCED_TABLE_SCHEMA

    Table schema.

  • REFERENCED_TABLE_NAME

    Name of the table.

  • WHERE_CLAUSE

    Expression used in theWHERE clause.

  • ALLOW_INSERT

    1 if inserts are allowed, otherwise0.

  • ALLOW_UPDATE

    1 if updates are allowed, otherwise0.

  • ALLOW_DELETE

    1 if deletes are allowed, otherwise0.

  • READ_ONLY

    1 if insert, update, or delete are not allowed, otherwise0. (In other words, this is1 only whenALLOW_INSERT,ALLOW_UPDATE, andALLOW_DELETE are all0.)

  • IS_ROOT_TABLE

    1 if this is the root table, otherwise0.

  • REFERENCED_TABLE_ID

    Unique table ID within this view.

  • REFERENCED_TABLE_PARENT_ID

    ID of the parent table.

  • REFERENCED_TABLE_PARENT_RELATIONSHIP

    One ofnested (arrays) orsingleton (otherwise).

TheJSON_DUALITY_VIEW_TABLES table was added in MySQL 9.4.0.