Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 38234 invoked from network); 17 Oct 2006 13:15:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 17 Oct 2006 13:15:07 -0000 Received: (qmail 63504 invoked by uid 500); 17 Oct 2006 13:15:04 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 63473 invoked by uid 500); 17 Oct 2006 13:15:04 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 63464 invoked by uid 99); 17 Oct 2006 13:15:04 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Oct 2006 06:15:04 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Oct 2006 06:15:03 -0700 Received: from d1-emea-09.sun.com (d1-emea-09.sun.com [192.18.2.119] (may be forged)) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k9HDEfUO013124 for ; Tue, 17 Oct 2006 14:14:41 +0100 (BST) Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0J7A00J017CFI400@d1-emea-09.sun.com> (original mail from Oystein.Grovlen@Sun.COM) for derby-dev@db.apache.org; Tue, 17 Oct 2006 14:14:41 +0100 (BST) Received: from [129.159.112.239] by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0J7A00ERS7G6O8VP@d1-emea-09.sun.com> for derby-dev@db.apache.org; Tue, 17 Oct 2006 14:14:33 +0100 (BST) Date: Tue, 17 Oct 2006 15:14:30 +0200 From: Oystein Grovlen - Sun Norway Subject: Show commands are not orthogonal Sender: Oystein.Grovlen@Sun.COM To: derby-dev@db.apache.org Message-id: <4534D736.9040000@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 8BIT User-Agent: Thunderbird 1.5.0.5 (X11/20060730) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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