Thread: getPrimaryKeys

getPrimaryKeys

From

David Gommeren

Date:

21 February 2006, 16:07:41

Hi,

Just discovered after messing around for two hours that the table-name
in DatabaseMetaData.getPrimaryKeys is case sensitive. I don't think this
should be.

JDBC version: 8.1-405 JDBC 2

Cheers,

David

Re: getPrimaryKeys

From

Kris Jurka

Date:

21 February 2006, 16:23:13


On Tue, 21 Feb 2006, David Gommeren wrote:

> Just discovered after messing around for two hours that the table-name in
> DatabaseMetaData.getPrimaryKeys is case sensitive. I don't think this should
> be.
>

How else would you differentiate between these two:

CREATE TABLE tab (a int primary key);
CREATE TABLE "TaB" (a int primary key);

Kris Jurka