Check which version of Derby you are using... This feature was introduced in 10.1.1 and should be present in 10.1.2 and later versions.

Satheesh

On 3/30/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
In the middle of page 29 of the Derby reference manual, there is an example of using Generated By Default:

create table greetings
(i int generated by default as identity, ch char(50));

Unfortunately, when I try to execute this statement, it gives me an error on the word "by".

Has support for "by default" been removed? If so, shouldn't the manual be updated to reflect that?

Reply via email to