MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
ndb_show_tables displays a list of all
NDB
database objects in the
cluster. By default, this includes not only both user-created
tables and NDB
system tables, but
NDB
-specific indexes, internal
triggers, and NDB Cluster Disk Data objects as well.
The following table includes options that are specific to the NDB Cluster native backup restoration program ndb_show_tables. Additional descriptions follow the table. For options common to most NDB Cluster programs (including ndb_show_tables), see Section 23.4.32, “Options Common to NDB Cluster Programs — Options Common to NDB Cluster Programs”.
Table 23.46 Command-line options for the ndb_show_tables program
Format | Description | Added, Deprecated, or Removed |
---|---|---|
Specifies database in which table is found; database name must be followed by table name | (Supported in all MySQL 8.0 based releases) |
|
Number of times to repeat output | (Supported in all MySQL 8.0 based releases) |
|
Return output suitable for MySQL LOAD DATA statement | (Supported in all MySQL 8.0 based releases) |
|
Show table temporary flag | (Supported in all MySQL 8.0 based releases) |
|
Limit output to objects of this type | (Supported in all MySQL 8.0 based releases) |
|
Do not qualify table names | (Supported in all MySQL 8.0 based releases) |
ndb_show_tables [-c connection_string
]
Specifies the name of the database in which the desired table is found. If this option is given, the name of a table must follow the database name.
If this option has not been specified, and no tables are
found in the TEST_DB
database,
ndb_show_tables issues a warning.
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
.
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 NDB
database objects to be listed (the default).
If specified, this causes unqualified object names to be displayed.
Only user-created NDB Cluster tables may be accessed from
MySQL; system tables such as SYSTAB_0
are
not visible to mysqld. However, you can
examine the contents of system tables using
NDB
API applications such as
ndb_select_all (see
Section 23.4.24, “ndb_select_all — Print Rows from an NDB Table”).
Prior to NDB 8.0.20, this program printed
NDBT_ProgramExit -
upon completion of
its run, due to an unnecessary dependency on the
status
NDBT
testing library. This dependency has
been removed, eliminating the extraneous output.