PURGE permanently deletes backup data from a table or all tables in the current project. Deleted backup data cannot be restored.
Warning
PURGE is irreversible. Once deleted, backup data cannot be recovered by any means. Run SHOW HISTORY FOR TABLES first to confirm which backup versions will be affected.
Syntax
Delete backup data from a single table
purge table <table_name>;| Parameter | Description |
|---|---|
table_name | The name of the table whose backup data you want to delete. |
Delete backup data from all tables in the current project
purge all;Deletes backup data from every table in the current project.
What's next
SHOW HISTORY FOR TABLES: View backup versions for a table before running PURGE.