~drizzle-trunk/drizzle/development : contents of docs/show.rst at revision 2471.1.1

~drizzle-trunk/drizzle/development : (revision 2471.1.1)

1878.5.4 by Brian Aker Update documentation.	1	SHOW
	2	=====
	3
1994.4.72 by Marisa Plumb edits	4	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.
1878.5.4 by Brian Aker Update documentation.	5
1878.5.4 by Brian Aker Update documentation.	6	SHOW SCHEMAS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	7	------------
	8
	9	Will list the names of all the schemas in the current catalog.
1878.5.4 by Brian Aker Update documentation.	10
1878.5.4 by Brian Aker Update documentation.	11	SHOW TABLES
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	12	-----------
	13
	14	Will list the names of all the tables in the current schema.
1878.5.4 by Brian Aker Update documentation.	15
1878.5.4 by Brian Aker Update documentation.	16	SHOW TEMPORARY TABLES
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	17	---------------------
1878.5.4 by Brian Aker Update documentation.	18
1878.5.4 by Brian Aker Update documentation.	19	SHOW TABLE STATUS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	20	-----------------
	21
2141.2.1 by Andrew Hutchings Make SHOW TABLE STATUS show the an AUTO_INCREMENT value	22	Will show the current status of tables for the current database which are
	23	currently in the table cache. A query (such as SELECT) may be needed to add a
	24	table to the table cache so that it can be shown in this output.
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	25
	26	SHOW COLUMNS FROM table_name
	27	----------------------------
1878.5.4 by Brian Aker Update documentation.	28
1878.5.4 by Brian Aker Update documentation.	29	SHOW INDEXES from table_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	30	----------------------------
1878.5.4 by Brian Aker Update documentation.	31
	32
	33	SHOW WARNINGS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	34	-------------
	35
	36	Shows the warnings and/or errors from the previous command.
1878.5.4 by Brian Aker Update documentation.	37
1878.5.4 by Brian Aker Update documentation.	38	SHOW ERRORS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	39	-----------
	40
	41	Shows errors from the previous command.
1878.5.4 by Brian Aker Update documentation.	42
1878.5.4 by Brian Aker Update documentation.	43	SHOW CREATE SCHEMA schema_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	44	------------------------------
	45
	46	Shows the CREATE SCHEMA command required to recreate schema_name.
1878.5.4 by Brian Aker Update documentation.	47
1878.5.4 by Brian Aker Update documentation.	48	SHOW CREATE TABLE table_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	49	----------------------------
	50
2141.2.1 by Andrew Hutchings Make SHOW TABLE STATUS show the an AUTO_INCREMENT value	51	Shows the CREATE TABLE statement used to create the table table_name. Please
	52	note the AUTO_INCREMENT in this is the AUTO_INCREMENT specified at CREATE or
	53	ALTER TABLE time, not the current AUTO_INCREMENT value.
1878.5.4 by Brian Aker Update documentation.	54
1878.5.4 by Brian Aker Update documentation.	55	SHOW PROCESSLIST
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	56	----------------
	57