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 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 |
Usage:
ndb_show_tables [-c connect_string
]
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
NDB
database 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_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 17.4.18, “ndb_select_all — Print Rows from an NDB Table”).
User Comments
Add your own comment.