> 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