MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4
The JSON_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.
The JSON_DUALITY_VIEW_TABLES
table
has the columns listed here:
TABLE_CATALOG
View catalog; this is always def
.
TABLE_SCHEMA
View schema.
TABLE_NAME
View name.
REFERENCED_TABLE_CATALOG
Table catalog; this is always def
.
REFERENCED_TABLE_SCHEMA
Table schema.
REFERENCED_TABLE_NAME
Name of the table.
WHERE_CLAUSE
Expression used in the WHERE
clause.
ALLOW_INSERT
1
if inserts are allowed, otherwise
0
.
ALLOW_UPDATE
1
if updates are allowed, otherwise
0
.
ALLOW_DELETE
1
if deletes are allowed, otherwise
0
.
READ_ONLY
1
if insert, update, or delete are not
allowed, otherwise 0
. (In other words, this
is 1
only when
ALLOW_INSERT
,
ALLOW_UPDATE
, and
ALLOW_DELETE
are all 0
.)
IS_ROOT_TABLE
1
if this is the root table, otherwise
0
.
REFERENCED_TABLE_ID
Unique table ID within this view.
REFERENCED_TABLE_PARENT_ID
ID of the parent table.
REFERENCED_TABLE_PARENT_RELATIONSHIP
One of nested
(arrays) or
singleton
(otherwise).
The JSON_DUALITY_VIEW_TABLES
table
was added in MySQL 9.4.0.