I find it strange that while "SHOW INDEXES", "SHOW PROCEDURES", and "SHOW SYNONYMS" by default list all corresponding objects in the database, "SHOW TABLES" and "SHOW VIEWS" by default only list the corresponding objects in the current schema. Would it not be better if all commands behaved the same way? Are there reasons for not changing this?
I also find it a bit strange that "SHOW VIEWS" uses the heading "TABLE_NAME" and not "VIEW_NAME". -- Øystein
