github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/xdoc/clear-data.txt (about) 1 PRAGMA secure_delete = ON; 2 delete from zd_def where 1=1; 3 delete from zd_field where 1=1; 4 delete from zd_ranges where 1=1; 5 delete from zd_ranges_item where 1=1; 6 delete from zd_instances where 1=1; 7 delete from zd_instances_item where 1=1; 8 delete from zd_excel where 1=1; 9 delete from zd_text where 1=1; 10 delete from zd_config where 1=1; 11 delete from zd_refer where 1=1; 12 delete from zd_section where 1=1; 13 vacuum; 14 PRAGMA secure_delete = OFF;