Error 42Y55

[sridhar devatha <de...@gmail.com>]

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

Re: Error 42Y55

[Kathey Marsden <km...@sbcglobal.net>]

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@gmail.com <ma...@gmail.com>> 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

Re: Error 42Y55

[Peter Ondruška <pe...@gmail.com>]

Perhaps you want to use:
drop table "tableName"

On Sat, Jul 4, 2009 at 8:10 AM, sridhar devatha
<de...@gmail.com>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
>