MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4
The JSON_DUALITY_VIEW_COLUMNS
table
shows information about all columns referenced by any JSON duality
view which is accessible by the current user. There is one row per
table reference.
The JSON_DUALITY_VIEW_COLUMNS
table
has the following columns:
TABLE_CATALOG
View catalog; this is always def
.
TABLE_SCHEMA
View schema.
TABLE_NAME
View name.
REFERENCED_TABLE_CATALOG
Table catalog; always def
.
REFERENCED_TABLE_SCHEMA
Table schema.
REFERENCED_TABLE_NAME
Table name.
IS_ROOT_TABLE
1
if this is the root table, otherwise
0
.
REFERENCED_TABLE_ID
Unique table ID within this view.
REFERENCED_TABLE_COLUMN_NAME
Column name.
JSON_KEY_NAME
JSON key name.
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
.)
The JSON_DUALITY_VIEW_COLUMNS
table
was added in MySQL 9.4.0.