NO CYCLE in Teradata in Teradata

While defining IDENTITY column like below, you will get the identity column in non-refresh mode. This means, even if you delete the rows from the table, Identity will store the last value and increment from that value.
column_name INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY
(START WITH 1 
INCREMENT BY 1 
MINVALUE 1
MAXVALUE 1000000
NO CYCLE)


To avoid this and to refresh the identity, you should use CYCLE instead of NO CYCLE.
column_name INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY
(START WITH 1 
INCREMENT BY 1 
MINVALUE 1
MAXVALUE 1000000
CYCLE)