Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.7Mb
PDF (A4) - 37.7Mb
PDF (RPM) - 37.0Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.3Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 214.6Kb
Man Pages (Zip) - 327.6Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

21.5.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.

Column NameTypeDescription
typeintegerType of DICT object; join on dict_obj_types to obtain the name
idintegerObject identifier
versionintegerObject version
stateintegerObject state
parent_obj_typeintegerParent object's type (a dict_obj_types type ID); 0 indicates that the object has no parent
parent_obj_idintegerParent object ID (such as a base table); 0 indicates that the object has no parent
fq_namestringFully 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.


User Comments
Sign Up Login You must be logged in to post a comment.