ndb_show_tables displays a list of all
NDBdatabase objects in the cluster. By default, this includes not only both user-created tables and
NDBsystem tables, but
NDB-specific indexes, internal triggers, and MySQL Cluster Disk Data objects as well.
The following table includes options that are specific to the MySQL Cluster program ndb_show_tables. Additional descriptions follow the table. For options common to all MySQL Cluster programs, see Section 17.4.23, “Options Common to MySQL Cluster Programs”.
Table 17.15. ndb_show_tables Command Line Options
Format Description Introduction Deprecated Removed --database=string Specifies the database in which the table is found --loops=# Number of times to repeat output --parsable Return output suitable for MySQL LOAD DATA INFILE statement --show-temp-status Show table temporary flag --type=# Limit output to objects of this type --unqualified Do not qualify table names
Specifies the name of the database in which the tables are found.
Specifies the number of times the utility should execute. This is 1 when this option is not specified, but if you do use the option, you must supply an integer argument for it.
Using this option causes the output to be in a format suitable for use with
LOAD DATA INFILE.
If specified, this causes temporary tables to be displayed.
Can be used to restrict the output to one type of object, specified by an integer type code as shown here:
1: System table
2: User-created table
3: Unique hash index
Any other value causes all
NDBdatabase objects to be listed (the default).
If specified, this causes unqualified object names to be displayed.
Only user-created Cluster tables may be accessed from MySQL; system tables such as
SYSTAB_0are not visible to mysqld. However, you can examine the contents of system tables using
NDBAPI applications such as ndb_select_all (see Section 17.4.18, “ndb_select_all — Print Rows from an NDB Table”).