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
|
SHOW
=====
All SHOW commands are shorthand forms of queries on the INFORMATION_SCHEMA and/or DATA_DICTIONARY. More data can be gained by executing queries directly on the tables found either the DATA_DICTIONARY or the INFORMATION_SCHEMA.
SHOW SCHEMAS
------------
Will list the names of all the schemas in the current catalog.
SHOW TABLES
-----------
Will list the names of all the tables in the current schema.
SHOW TEMPORARY TABLES
---------------------
SHOW TABLE STATUS
-----------------
Will show the current status of tables for the current database which are
currently in the table cache. A query (such as SELECT) may be needed to add a
table to the table cache so that it can be shown in this output.
SHOW COLUMNS FROM table_name
----------------------------
SHOW INDEXES from table_name
----------------------------
SHOW WARNINGS
-------------
Shows the warnings and/or errors from the previous command.
SHOW ERRORS
-----------
Shows errors from the previous command.
SHOW CREATE SCHEMA schema_name
------------------------------
Shows the CREATE SCHEMA command required to recreate schema_name.
SHOW CREATE TABLE table_name
----------------------------
Shows the CREATE TABLE statement used to create the table table_name. Please
note the AUTO_INCREMENT in this is the AUTO_INCREMENT specified at CREATE or
ALTER TABLE time, not the current AUTO_INCREMENT value.
SHOW PROCESSLIST
----------------
|