Re: Error 42Y55

by devathasridhar :: Rate this Message:

Hi kathey marsden,

Thank you very much. You are absolutely correct. As a new derby user, I may have accidentally created the table in the default schema(APP). Please add these issues and solutions in a common place. So that we prevent the traffic to derby user.

Hi Bryan Pendleton,
That command only lead me to the above solutions. Thank you very much Bryan.

Regards,
Sridhar

--- On Sat, 4/7/09, Kathey Marsden <kmarsdenderby@...> wrote:

> From: Kathey Marsden <kmarsdenderby@...>
> Subject: Re: Error 42Y55
> To: "Derby Discussion" <derby-user@...>
> Date: Saturday, 4 July, 2009, 7:43 PM
> 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
>
>

See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/

« Return to Thread: error 42Y55