db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: SQLException Table does not exist although just created
Date Tue, 15 Dec 2009 13:58:01 GMT
Wildman <wleue1@nycap.rr.com> writes:

> Thanks, Rick -- that is indeed quite helpful.
> I am a bit unsure of how to specify the table name so that it retains
> lower-case. If I quote the name when creating the table; e.g. "create table
> 'part_type' ( .... )" then I get a SQL error complaining about the quotes.
> Is there another way to specify a table name including casing?

Hi Bill,

You need to use double-quotes for SQL identifiers (single-quotes are
only for string literals):

  create table "part_type" ( .... )

Knut Anders

View raw message