Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 297.3Kb
Man Pages (Zip) - 402.5Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

25.6.16.24 The ndbinfo dict_obj_info Table

Thedict_obj_info table provides information aboutNDB data dictionary (DICT) objects such as tables and indexes. (Thedict_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.

Thedict_obj_info table contains the following columns:

  • type

    Type ofDICT object; join ondict_obj_types to obtain the name

  • id

    Object identifier; for Disk Data undo log files and data files, this is the same as the value shown in theLOGFILE_GROUP_NUMBER column of the Information SchemaFILES table; for undo log files, it also the same as the value shown for thelog_id column in thendbinfologbuffers andlogspaces tables

  • version

    Object version

  • state

    Object state; seeObject::State for values and descriptions.

  • parent_obj_type

    Parent object's type (adict_obj_types type ID); 0 indicates that the object has no parent

  • parent_obj_id

    Parent object ID (such as a base table); 0 indicates that the object has no parent

  • fq_name

    Fully qualified object name; for a table, this has the formdatabase_name/def/table_name, for a primary key, the form issys/def/table_id/PRIMARY, and for a unique key it issys/def/table_id/uk_name$unique