Error 42Y55

[sridhar devatha]

Hi,

I am getting the
ij> drop table tableName;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it
does not exist.
ij> exit

But, the table exists.
I verified using sys.systables.
what could be the reason.
I am using netbeans to generate hibernate mappings.
I also open command windows for server and another for connecting through ij  apart from netbeans.
I closed netbeans. I restarted the server. Tried to drop the table. Still I am getting the same error.
any body please help.
--

Yours Sincerely,
Sridhar

[Peter Ondruška]

Perhaps you want to use:

drop table "tableName"

On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha <devatha.sridhar@...> wrote:

Hi,

I am getting the
ij> drop table tableName;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName' because it
does not exist.
ij> exit

But, the table exists.
I verified using sys.systables.
what could be the reason.
I am using netbeans to generate hibernate mappings.
I also open command windows for server and another for connecting through ij  apart from netbeans.
I closed netbeans. I restarted the server. Tried to drop the table. Still I am getting the same error.
any body please help.
--

Yours Sincerely,
Sridhar

[Kathey Marsden]

Peter Ondruška wrote:

> Perhaps you want to use:
>
> drop table "tableName"
>
> On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha
> <devatha.sridhar@... <mailto:devatha.sridhar@...>> wrote:
>
>     Hi,
>
>     I am getting the
>     ij> drop table tableName;
>     ERROR 42Y55: 'DROP TABLE' cannot be performed on 'tableName'
>     because it
>     does not exist.
>

The default schema corresponds to the name of the user that connected
(or APP if there is no user). Perhaps your table is in a different
schema. If you created the table as USER1 and are now connected as
USER2, you may want to try ij> drop table USER1.TABLENAME;

Kathey