1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
.\" Title: \fBndb_show_tables\fR
.\" Author:
.\" Generator: DocBook XSL Stylesheets v1.70.1 <http://docbook.sf.net/>
.\" 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/).
|
