Purge

Updated at: 2025-04-16 06:04

Deletes the backup data from the current table or all tables in a project. The backup data that is deleted cannot be restored

Precautions

The backup data that is deleted from a table cannot be restored. Proceed with caution.

Syntax

  • Delete the backup data from a single table. Sample statement:

    purge table <table_name>;

    table_name: the name of the table from which you want to delete the backup data.

  • Delete the backup data from all tables in the current project. Sample statement:

    purge all;

Related statements

SHOW HISTORY FOR TABLES:View the backup information of the table.

  • On this page (1)
  • Precautions
  • Syntax
  • Related statements
Feedback