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;