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
