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