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 dict_obj_info
table contains the
following columns:
type
Type of
DICT
object; join ondict_obj_types
to obtain the nameid
Object identifier; for Disk Data undo log files and data files, this is the same as the value shown in the
LOGFILE_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 thendbinfo
logbuffers
andlogspaces
tablesversion
Object version
state
Object state; see Object::State for values and descriptions.
parent_obj_type
Parent object's type (a
dict_obj_types
type ID); 0 indicates that the object has no parentparent_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 form
, for a primary key, the form isdatabase_name
/def/table_name
sys/def/
, and for a unique key it istable_id
/PRIMARYsys/def/
table_id
/uk_name
$unique