# Audit Trail Maintenance

It is advisable to develop a maintenance program/plan for the audit table. The most basic version would be to periodically delete items older than a certain date. The following example deletes items older than 3 month from today:

    delete from AuditTrail where Timestamp < datetime ('now' , '-3 month')

Note: For more information on date and time functions in SQLite, SQLite Date and Time Functions.