Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Message-ID: <22558480.post@talk.nabble.com>
Date: Tue, 17 Mar 2009 06:25:48 -0700 (PDT)
From: bigblop <fedevaps@yahoo.dk>
To: derby-user@db.apache.org
Subject: "create table if not exists" ?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


I have this line i a derby script:

create table derbyDB(num int, addr varchar(40));

But the second time I run the script I get:

Table/View 'DERBYDB' already exists in Schema 'APP'. [SQL State=X0Y32, DB
Errorcode=20000] 

In mySQL I could use IF NOT EXISTS like:


create table if not exists derbyDB(num int, addr varchar(40));

But I get an error when doing that with Derby. Is there something equivalent
in derby to IF NOT EXISTS ?
-- 
View this message in context: http://www.nabble.com/%22create-table-if-not-exists%22---tp22558480p22558480.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.