db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein Grovlen - Sun Norway <Oystein.Grov...@Sun.COM>
Subject Show commands are not orthogonal
Date Tue, 17 Oct 2006 13:14:30 GMT

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

Mime
View raw message