db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Wooldridge <brett.wooldri...@gmail.com>
Subject Drop "GENERATED BY DEFAULT"
Date Wed, 19 May 2010 00:32:32 GMT
Hi All,

I have a table something like this:

CREATE TABLE test (
   id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL,
   ...
   PRIMARY KEY (id)
);

I wish to DROP the "GENERATED BY DEFAULT AS IDENTITY" from column 'id'.
Looking at the various ALTER TABLE forms, I cannot seem to find a way to do
it.
There are a lot of other tables with foreign key references to this column,
so
dropping and recreating the column doesn't seem viable.  Is there a
supported way
to do it, or even an unsupported way by manipulating system tables?

Thanks,
Brett

Mime
View raw message