db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmarsdende...@sbcglobal.net>
Subject Re: Error 42Y55
Date Sat, 04 Jul 2009 14:13:17 GMT
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 <mailto:devatha.sridhar@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


Mime
View raw message