~drizzle-trunk/drizzle/development

Viewing changes to docs/show.rst

Merge Andrew - 702575: Need to document bug #622472
Merge Andrew - 702878: "Show table status" needs an overhaul

added added

removed removed

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 CREATE TABLE table_name

----------------------------

Shows the CREATE TABLE statement used to create the 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

----------------