ALTER TABLE and lower case table names
From: Erik McBeth <emcbeth_at_wpo.borland.com>
Date: 1995/04/11
Message-ID: <3meqp7$a21_at_druid.borland.com>#1/1
Date: 1995/04/11
Message-ID: <3meqp7$a21_at_druid.borland.com>#1/1
If I create a lower case table name via: CREATE TABLE "foo"(F1 CHAR(10) NOT NULL)
I am unable to issue:
ALTER TABLE "foo" ADD PRIMARY KEY(F1)
The table cannot be found.
Doing a
SELECT * FROM "foo"
is ok. Received on Tue Apr 11 1995 - 00:00:00 CEST