Documentation Home
MySQL NDB Cluster 8.0
Related Documentation Download this Excerpt

7.10.15 The ndbinfo dict_obj_info Table

The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent object (if any), and fully qualified name.

The following table provides information about the columns in the dict_obj_info table. For each column, the table shows the name, data type, and a brief description.

Table 7.28 Columns of the dict_obj_info table

Column Name Type Description
type integer Type of DICT object; join on dict_obj_types to obtain the name
id integer Object identifier
version integer Object version
state integer Object state
parent_obj_type integer Parent object's type (a dict_obj_types type ID); 0 indicates that the object has no parent
parent_obj_id integer Parent object ID (such as a base table); 0 indicates that the object has no parent
fq_name string Fully qualified object name; for a table, this has the form database_name/def/table_name, for a primary key, the form is sys/def/table_id/PRIMARY, and for a unique key it is sys/def/table_id/uk_name$unique