Hi,

I've created table by mistake.

CREATE TABLE TEST (
DEF_ID BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 32672 NO CYCLE CACHE 20),
PROPERTY_NAME VARCHAR(50) NOT NULL
)


It has MAXVALUE for IDENTITY But i was too small can I increase max or actually I would like to drop the max value is that posible?

Thank you in advance.

The manual states which modifications can be done on an IDENTITY column: Modifying the generated or identity property of a column

If you try an "ALTER TABLE ... ALTER COLUMN ... SET GENERATED BY DEFAULT AS IDENTITY ( MAXVALUE 65536 )", you get an error SQL0190. The explanation for that error states:
Combining this with the above, you have to drop the identity property from the column and re-add.

Thank you for the replied.

After re-add the identity. The identity is restart to 1 but i still have data in the table. Do you know how to restart identity?

You use a different value in the "START WITH 1" clause.