Example: Using DeleteAccessLogV - Teradata VantageCloud Lake

The following statement deletes entries logged more than 30 days before the current calendar date:

DELETE FROM DBC.DeleteAccessLogV ALL;

Result:

DELETE COMPLETED. 79 RECORDS DELETED.