> SHOW TABLES does not make sense. How are you going to join the
> output of SHOW TABLES against the output of SHOW COLUMNS and
> SHOW INDEXES?
In MySQL, by parsing the output of SHOW CREATE TABLE.
It would be a boon if someone were to write a utility, in an OS-independent
language, which does that parsing for all tables in a MySQL database and
returns SQL output that's suitable for creating a set of system tables.
Obviously bits of this task have already been accomplished by the folks who
wrote the MySQL module in PHP, for example, and for all we know, much of the
code for doing it may already exist in phpMyAdmin.
PB

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.