ALTER TABLE RELEASE ROWS Examples - Advanced SQL Engine - Teradata Database

Example: Remove Logically Deleted Rows

ALTER TABLE lditab1 RELEASE ROWS;

Example: Remove Logically Deleted Rows and Reset RowLoadID

ALTER TABLE lditabl2 RELEASE DELETED ROWS AND RESET LOAD IDENTITY;