From derby-user-return-10562-apmail-db-derby-user-archive=db.apache.org@db.apache.org Fri Feb 20 23:40:34 2009
Return-Path: <derby-user-return-10562-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 14201 invoked from network); 20 Feb 2009 23:40:34 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Feb 2009 23:40:34 -0000
Received: (qmail 98579 invoked by uid 500); 20 Feb 2009 23:40:33 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 98552 invoked by uid 500); 20 Feb 2009 23:40:32 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 98543 invoked by uid 99); 20 Feb 2009 23:40:32 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Feb 2009 15:40:32 -0800
X-ASF-Spam-Status: No, hits=0.4 required=10.0
	tests=FORGED_YAHOO_RCVD,RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.2 as permitted sender)
Received: from [80.91.229.2] (HELO ciao.gmane.org) (80.91.229.2)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Feb 2009 23:40:23 +0000
Received: from root by ciao.gmane.org with local (Exim 4.43)
	id 1LaeyR-0000xp-1j
	for derby-user@db.apache.org; Fri, 20 Feb 2009 23:40:03 +0000
Received: from franklin.dieselpoint.com ([75.5.156.70])
        by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <derby-user@db.apache.org>; Fri, 20 Feb 2009 23:40:03 +0000
Received: from shef31 by franklin.dieselpoint.com with local (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <derby-user@db.apache.org>; Fri, 20 Feb 2009 23:40:03 +0000
X-Injected-Via-Gmane: http://gmane.org/
To: derby-user@db.apache.org
From:  Chris <shef31@yahoo.com>
Subject:  Create table if not exists?
Date:  Fri, 20 Feb 2009 17:30:38 -0600
Lines: 7
Message-ID: <gnneeu$5lb$1@ger.gmane.org>
Mime-Version:  1.0
Content-Type:  text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding:  7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: franklin.dieselpoint.com
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
Sender: news <news@ger.gmane.org>
X-Virus-Checked: Checked by ClamAV on apache.org

MySQL has a really nice syntax for creating tables if they don't exist 
already:

CREATE TABLE IF NOT EXISTS foo (...)

How can I get the same functionality in Derby? I haven't been able to 
figure out the SQL command to check for the existence of a table.