« Return to Thread: Error 42Y55

Re: Error 42Y55

by Peter Ondruška :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Error 42Y55