drop schema lars; results in syntax error [message #34890] |
Sun, 19 August 2007 22:45 |
|
Hello,
I have in Derby 10.2.2.0 a schema called "lars". This was created via the
SQL Editor and the following statement:
create schema lars;
I'm not able to delete this schema. If I type the following into the SQL
Editor:
drop schema lars;
The SQL Editor returns with an error message:
Syntax error: Encountered "<EOF>" at line 2, column 18.
Can you please check? I assume this is a bug and will open a bug report for
this if noone know a solution for this.
Best regards, Lars
|
|
|
Re: drop schema lars; results in syntax error [message #34944 is a reply to message #34890] |
Mon, 20 August 2007 02:31 |
Eclipse User |
|
|
|
Originally posted by: hui.cao.sybase.ocm
Hi Lars,
The error comes from Derby server and this is not a bug. You should use:
drop schema lars RESTRICT;
instead.
Here's the exerpt from the Derby manual:
The RESTRICT keyword enforces the rule that no objects can be defined in the
specified
schema for the schema to be deleted from the database. The RESTRICT keyword
is
required
--
Best Regards!
Max (Hui) Cao
Sybase Shanghai RD
"Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
news:faah63$s73$1@build.eclipse.org...
> Hello,
>
> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
> SQL Editor and the following statement:
>
> create schema lars;
>
> I'm not able to delete this schema. If I type the following into the SQL
> Editor:
>
> drop schema lars;
>
> The SQL Editor returns with an error message:
>
> Syntax error: Encountered "<EOF>" at line 2, column 18.
>
> Can you please check? I assume this is a bug and will open a bug report
> for this if noone know a solution for this.
>
> Best regards, Lars
>
|
|
|
Re: drop schema lars; results in syntax error [message #35080 is a reply to message #34944] |
Mon, 20 August 2007 18:32 |
|
Hi Hui,
thank you.
Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:faaue1$io$1@build.eclipse.org...
> Hi Lars,
> The error comes from Derby server and this is not a bug. You should
> use:
> drop schema lars RESTRICT;
> instead.
> Here's the exerpt from the Derby manual:
> The RESTRICT keyword enforces the rule that no objects can be defined in
> the specified
> schema for the schema to be deleted from the database. The RESTRICT
> keyword is
> required
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:faah63$s73$1@build.eclipse.org...
>> Hello,
>>
>> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
>> SQL Editor and the following statement:
>>
>> create schema lars;
>>
>> I'm not able to delete this schema. If I type the following into the SQL
>> Editor:
>>
>> drop schema lars;
>>
>> The SQL Editor returns with an error message:
>>
>> Syntax error: Encountered "<EOF>" at line 2, column 18.
>>
>> Can you please check? I assume this is a bug and will open a bug report
>> for this if noone know a solution for this.
>>
>> Best regards, Lars
>>
>
>
|
|
|
|
Re: drop schema lars; results in syntax error [message #587468 is a reply to message #34944] |
Mon, 20 August 2007 18:32 |
|
Hi Hui,
thank you.
Best regards, Lars
"Hui Cao" <hui.cao@sybase.ocm> wrote in message
news:faaue1$io$1@build.eclipse.org...
> Hi Lars,
> The error comes from Derby server and this is not a bug. You should
> use:
> drop schema lars RESTRICT;
> instead.
> Here's the exerpt from the Derby manual:
> The RESTRICT keyword enforces the rule that no objects can be defined in
> the specified
> schema for the schema to be deleted from the database. The RESTRICT
> keyword is
> required
>
> --
> Best Regards!
>
> Max (Hui) Cao
> Sybase Shanghai RD
>
>
> "Lars Vogel" <Lars.Vogel@gmail.com> wrote in message
> news:faah63$s73$1@build.eclipse.org...
>> Hello,
>>
>> I have in Derby 10.2.2.0 a schema called "lars". This was created via the
>> SQL Editor and the following statement:
>>
>> create schema lars;
>>
>> I'm not able to delete this schema. If I type the following into the SQL
>> Editor:
>>
>> drop schema lars;
>>
>> The SQL Editor returns with an error message:
>>
>> Syntax error: Encountered "<EOF>" at line 2, column 18.
>>
>> Can you please check? I assume this is a bug and will open a bug report
>> for this if noone know a solution for this.
>>
>> Best regards, Lars
>>
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.04506 seconds