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

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

1878.5.4 by Brian Aker Update documentation.	1	SHOW
	2	=====
	3
	4	All show commans are mapped to table functions in Drizzle. More data can be
	5	gained by exeucting queries directly on the tables found either the
	6	DATA_DICTIONARY or the INFORMATION_SCHEMA.
	7
	8	SHOW SCHEMAS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	9	------------
	10
	11	Will list the names of all the schemas in the current catalog.
1878.5.4 by Brian Aker Update documentation.	12
1878.5.4 by Brian Aker Update documentation.	13	SHOW TABLES
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	14	-----------
	15
	16	Will list the names of all the tables in the current schema.
1878.5.4 by Brian Aker Update documentation.	17
1878.5.4 by Brian Aker Update documentation.	18	SHOW TEMPORARY TABLES
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	19	---------------------
1878.5.4 by Brian Aker Update documentation.	20
1878.5.4 by Brian Aker Update documentation.	21	SHOW TABLE STATUS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	22	-----------------
	23
	24
	25	SHOW COLUMNS FROM table_name
	26	----------------------------
1878.5.4 by Brian Aker Update documentation.	27
1878.5.4 by Brian Aker Update documentation.	28	SHOW INDEXES from table_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	29	----------------------------
1878.5.4 by Brian Aker Update documentation.	30
	31
	32	SHOW WARNINGS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	33	-------------
	34
	35	Shows the warnings and/or errors from the previous command.
1878.5.4 by Brian Aker Update documentation.	36
1878.5.4 by Brian Aker Update documentation.	37	SHOW ERRORS
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	38	-----------
	39
	40	Shows errors from the previous command.
1878.5.4 by Brian Aker Update documentation.	41
1878.5.4 by Brian Aker Update documentation.	42	SHOW CREATE SCHEMA schema_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	43	------------------------------
	44
	45	Shows the CREATE SCHEMA command required to recreate schema_name.
1878.5.4 by Brian Aker Update documentation.	46
1878.5.4 by Brian Aker Update documentation.	47	SHOW CREATE TABLE table_name
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	48	----------------------------
	49
	50	Shows the CREATE TABLE statement used to create the table table_name.
1878.5.4 by Brian Aker Update documentation.	51
1878.5.4 by Brian Aker Update documentation.	52	SHOW PROCESSLIST
1900.2.16 by Stewart Smith slightly fill out the SHOW documentation	53	----------------
	54