DEV Community

Eduardo Issao Ito
Eduardo Issao Ito

Posted on

2 2

DB2: Restart Identity

How to restart the value of an identity column.

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

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay