====== Clear Table and reset Identity Column ======

    TRUNCATE TABLE mytable RESTART IDENTITY;

See [[https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_73/db2/rbafztruncate.htm | IBM Knowledge Center]]

{{tag>ibm devel sql}}