~drizzle-trunk/drizzle/development

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
----------------