Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 55601 invoked from network); 11 Jan 2005 18:46:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 11 Jan 2005 18:46:17 -0000 Received: (qmail 25387 invoked by uid 500); 11 Jan 2005 18:46:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 25227 invoked by uid 500); 11 Jan 2005 18:46:16 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 25211 invoked by uid 99); 11 Jan 2005 18:46:16 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from brmea-mail-4.Sun.COM (HELO brmea-mail-4.sun.com) (192.18.98.36) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 11 Jan 2005 10:46:15 -0800 Received: from phys-bur-1 ([129.148.9.72]) by brmea-mail-4.sun.com (8.12.10/8.12.9) with ESMTP id j0BIkDdt005845 for ; Tue, 11 Jan 2005 11:46:13 -0700 (MST) Received: from conversion-daemon.bur-mail1.east.sun.com by bur-mail1.east.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IA6000011G0EE@bur-mail1.east.sun.com> (original mail from Lance.Andersen@Sun.COM) for derby-user@db.apache.org; Tue, 11 Jan 2005 13:46:12 -0500 (EST) Received: from Sun.COM (ace.East.Sun.COM [129.148.71.167]) by bur-mail1.east.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTPA id <0IA600EJZ1H0KL@bur-mail1.east.sun.com> for derby-user@db.apache.org; Tue, 11 Jan 2005 13:46:12 -0500 (EST) Date: Tue, 11 Jan 2005 13:46:06 -0500 From: Lance Andersen Subject: Re: SHOW TABLES equiv. To: Derby Discussion Reply-to: Lance.Andersen@Sun.COM Message-id: <41E41EEE.6080106@Sun.COM> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.0.1) Gecko/20020824 Netscape/7.0 References: <41E3480A.4070909@Golux.Com> <41E405EF.5050301@Source-Zone.com> X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I do think it would be useful to add a feature to derby similar to sp_help/describe. Kathy Saunders wrote: > myrnap wrote: > >> SD wrote: >> >>> Hello, I'm changing our current project from Mysql to use >>> Cloudscape/Derby. >>> >>> I'm having trouble locating the SQL/commands to list the tables that >>> are currently in the Cloudscape/Derby db. >>> >>> In Mysql I use "SHOW TABLES". >>> >>> What is the equivalent sql/command for Cloudscape/Derby? >>> >>> BTW I've tried selecting on SYSTABLES but the SYSTABLES table doesn't >>> exist. >>> >>> Thank you in advance. >>> >>> SD. >>> >> It's in a schema called sys, i.e.: >> >> select * from sys.systables >> >> Myrna >> >> > You can also use the dblook utility to dump the schema. > > Kathy -- Lance Andersen email: Lance.Andersen@sun.com Sun Microsystems Inc. phone: (781) 442-2037 1 Network Drive, UBUR02-301 fax : (781) 442-1610 Burlington, MA 01803