Tuesday, June 2, 2009

DB2-AS/400 SQL - Restarting Identity Counter

SQL statement for resetting the identity counter, after clearing the table.
Database Server: IBM AS/400 DB2

ALTER TABLE <TABLE NAME> ALTER COLUMN <IDENTITY COLUMN> RESTART WITH 1