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 (asf.osuosl.org: local policy)
Date: Mon, 26 Sep 2005 12:39:23 +0200
From: "Bernt M. Johnsen" <Bernt.Johnsen@Sun.COM>
Subject: Re: Equivalent of SQL "DROP TABLE IF EXISTS MY_TABLE" ?
In-reply-to: <20050926100926.GB30511@atum01.norway.sun.com>
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <20050926103923.GA30714@atum01.norway.sun.com>
Organization: Sun Microsystems
MIME-version: 1.0
Content-type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary="PEIAKu/WMn1b1Hv9"
Content-disposition: inline
User-Agent: Mutt/1.5.9i
References: <20050926175743.AFC1.WOLFGANG127US@yahoo.co.jp>
 <20050926100926.GB30511@atum01.norway.sun.com>


--PEIAKu/WMn1b1Hv9
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

>>>>>>>>>>>> Bernt M. Johnsen wrote (2005-09-26 12:09:26):
> >>>>>>>>>>>> wolfgang127us@yahoo.co.jp wrote (2005-09-26 18:11:26):
> > Hi there,
> >=20
> > To initialize my database, I want to use an SQL=20
> > equivalent of "DROP TABLE IF EXISTS MY_TABLE" .
> >=20
> > I've tried it but of course didn't work
> >=20
> > Does Derby support this kinda SQL or Is there any workaround
> > I can drop a table if it exists ??
>=20
> One way could be:
>         try {
>             stmt.executeUpdate("DROP TABLE MY_TABLE");
>         } catch (SQL_Exception e) {
>             if (!e.getSQLState().equals("proper SQL-state for table does =
not exist"))

In Derby it is:
             if (!e.getSQLState().equals("42Y55"))

--=20
Bernt Marius Johnsen, Database Technology Group,=20
Sun Microsystems, Trondheim, Norway

--PEIAKu/WMn1b1Hv9
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFDN8/alFBD9TXBAPARAnmSAJ9A7gx5ZUrKnkvJ9rokNxVon5eD8ACg2OL+
dnPLlhK3oNftD9cJxD+pK3c=
=vTQ6
-----END PGP SIGNATURE-----

--PEIAKu/WMn1b1Hv9--