Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.2Mb
PDF (A4) - 39.3Mb
PDF (RPM) - 38.5Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.6Mb
Man Pages (TGZ) - 223.4Kb
Man Pages (Zip) - 332.3Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual 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 21.292 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

This table was added in NDB 7.5.4.