DEV Community

loading...

DB2: Restart Identity

Eduardo Issao Ito
Software architect, developer, learner.
・1 min read

How to restart the value of an identity column.

ALTER TABLE <table_name> ALTER COLUMN <identity_column_name> RESTART WITH <counter_value>

Discussion (0)