Re: Error 42Y55

by Kathey Marsden :: Rate this Message:

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

« Return to Thread: Error 42Y55