.\" Title: \fBndb_show_tables\fR .\" Author: .\" Generator: DocBook XSL Stylesheets v1.70.1 .\" Date: 01/11/2008 .\" Manual: MySQL Database System .\" Source: MySQL 5.0 .\" .TH "\fBNDB_SHOW_TABLES\\F" "1" "01/11/2008" "MySQL 5.0" "MySQL Database System" .\" disable hyphenation .nh .\" disable justification (adjust text to left margin only) .ad l .SH "NAME" ndb_show_tables \- display list of NDB tables .SH "SYNOPSIS" .HP 26 \fBndb_show_tables [\fR\fB\fIoptions\fR\fR\fB]\fR .SH "DESCRIPTION" .PP \fBndb_show_tables\fR 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, and internal triggers, as well. .PP \fBUsage\fR: .sp .RS 3n .nf ndb_show_tables [\-c \fIconnect_string\fR] .fi .RE .PP \fBAdditional Options\fR: .TP 3n \(bu \fB\-\-loops\fR, \fB\-l\fR .sp 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. .TP 3n \(bu \fB\-\-parsable\fR, \fB\-p\fR .sp Using this option causes the output to be in a format suitable for use with LOAD DATA INFILE. .TP 3n \(bu \fB\-\-type\fR, \fB\-t\fR .sp Can be used to restrict the output to one type of object, specified by an integer type code as shown here: .RS 3n .TP 3n \(bu \fB1\fR: System table .TP 3n \(bu \fB2\fR: User\-created table .TP 3n \(bu \fB3\fR: Unique hash index .RE .IP "" 3n Any other value causes all NDB database objects to be listed (the default). .TP 3n \(bu \fB\-\-unqualified\fR, \fB\-u\fR .sp If specified, this causes unqualified object names to be displayed. .sp .RE .sp .it 1 an-trap .nr an-no-space-flag 1 .nr an-break-flag 1 .br \fBNote\fR .PP Only user\-created Cluster tables may be accessed from MySQL; system tables such as SYSTAB_0 are not visible to \fBmysqld\fR. However, you can examine the contents of system tables using NDB API applications such as \fBndb_select_all\fR (see \fBndb_select_all\fR(1)). .SH "COPYRIGHT" .PP Copyright 2007\-2008 MySQL AB .PP This documentation is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. .PP This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. .PP You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110\-1301 USA or see http://www.gnu.org/licenses/. .SH "SEE ALSO" For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. .SH AUTHOR MySQL AB (http://www.mysql.com/).