Information about multiple tables can be obtained in a single invocation of ndb_desc  by using their names, separated by spaces. All of the tables must be in the same database. 

You can obtain additional information about a specific index using the --table  (short form: -t ) option and supplying the name of the index as the first argument to ndb_desc , as shown here: 

shell> ./ndb_desc uk -d test -t fish -- uk -- Version: 2 Base table: fish Number of attributes: 1 Logging: 0 Index type: OrderedIndex Index status: Retrieved -- Attributes -- name Varchar(20;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY -- IndexTable 10/uk -- Version: 2 Fragment type: FragUndefined K Value: 6 Min load factor: 78 Max load factor: 80 Temporary table: yes Number of attributes: 2 Number of primary keys: 1 Length of frm data: 0 Max Rows: 0 Row Checksum: 1 Row GCI: 1 SingleUserMode: 2 ForceVarPart: 0 PartitionCount: 2 FragmentCount: 2 FragmentCountType: ONE_PER_LDM_PER_NODE ExtraRowGciBits: 0 ExtraRowAuthorBits: 0 TableStatus: Retrieved Table options: -- Attributes -- name Varchar(20;latin1_swedish_ci) NOT NULL AT=SHORT_VAR ST=MEMORY NDB$TNODE Unsigned [64] PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY -- Indexes -- PRIMARY KEY(NDB$TNODE) - UniqueHashIndex NDBT_ProgramExit: 0 - OK 

When an index is specified in this way, the --extra-partition-info  and --extra-node-info options have no effect. 

The Version  column in the output contains the table’s schema object version. For information about interpreting this value, see NDB Schema Object Versions. 

Three of the table properties that can be set using NDB_TABLE  comments embedded in CREATE TABLE and ALTER TABLE  statements are also visible in ndb_desc  output. The table’s FRAGMENT_COUNT_TYPE is always shown in the FragmentCountType  column. READ_ONLY  and FULLY_REPLICATED , if set to 1, are shown in the Table options  column. You can see this after executing the following ALTER TABLE statement in the mysql  client: 

mysql> ALTER TABLE fish COMMENT=’NDB_TABLE=READ_ONLY=1,FULLY_REPLICATED=1’; 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G | Level | Code | Message 

