← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/show.rst

  • Committer: Lee Bieber
  • Date: 2010-11-07 19:30:38 UTC
  • mfrom: (1900.2.19 doc)
  • mto: This revision was merged to the branch mainline in revision 1911.
  • Revision ID: kalebral@gmail.com-20101107193038-za7npsylo72caprx
Merge Stewart - including adapting and expanding the "differences from mysql" page from the wiki.

Show diffs side-by-side

added added

removed removed

Lines of Context:
docs/show.rst
6
6
DATA_DICTIONARY or the INFORMATION_SCHEMA.
7
7
 
8
8
SHOW SCHEMAS
 
9
------------
 
10
 
 
11
Will list the names of all the schemas in the current catalog.
9
12
 
10
13
SHOW TABLES
 
14
-----------
 
15
 
 
16
Will list the names of all the tables in the current schema.
11
17
 
12
18
SHOW TEMPORARY TABLES
 
19
---------------------
13
20
 
14
21
SHOW TABLE STATUS
15
 
 
16
 
 
17
 
SHOW COLUMNS FROM table_name 
 
22
-----------------
 
23
 
 
24
 
 
25
SHOW COLUMNS FROM table_name
 
26
----------------------------
18
27
 
19
28
SHOW INDEXES from table_name
 
29
----------------------------
20
30
 
21
31
 
22
32
SHOW WARNINGS
 
33
-------------
 
34
 
 
35
Shows the warnings and/or errors from the previous command.
23
36
 
24
37
SHOW ERRORS
 
38
-----------
 
39
 
 
40
Shows errors from the previous command.
25
41
 
26
42
SHOW CREATE SCHEMA schema_name
 
43
------------------------------
 
44
 
 
45
Shows the CREATE SCHEMA command required to recreate schema_name.
27
46
 
28
47
SHOW CREATE TABLE table_name
 
48
----------------------------
 
49
 
 
50
Shows the CREATE TABLE statement used to create the table table_name.
29
51
 
30
52
SHOW PROCESSLIST
 
53
----------------
 
54