Differences

This shows you the differences between two versions of the page.

Link to this comparison view

clear_table_and_reset_identity_column [2018/07/09 08:41]
clear_table_and_reset_identity_column [2021/04/05 11:23] (current)
Line 1: Line 1:
 +====== 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}}