useful-qry/table-controls/테이블-truncate.sql

truncate table dbr_item;
truncate table dbr_item_thm;

truncate table dbr_last_slip_no;
truncate table pro_member;
truncate table pro_member_app;
truncate table pro_member_ext;
truncate table dbr_company;

truncate table dbr_squote;
truncate table dbr_squote_bd;

truncate table dbr_sorder;
truncate table dbr_sorder_bd;

truncate table dbr_last_slip_no;

truncate table dbr_sorder;
truncate table dbr_sorder_bd;
truncate table dbr_sales;
truncate table dbr_sales_bd;

truncate table dbr_credit_bd;
truncate table dbr_credit;

truncate table dbr_genio_bd;
truncate table dbr_genio;

truncate table dbr_pquote_bd;
truncate table dbr_pquote;
truncate table dbr_porder_bd;
truncate table dbr_porder;
truncate table dbr_purch_bd;
truncate table dbr_purch;

truncate table dbr_credit;
truncate table dbr_credit_bd;
truncate table dbr_reward;
truncate table dbr_reward_bd;

truncate table dbr_bal_item;
truncate table dbr_bal_buyer;
truncate table dbr_bal_supplier;
truncate table dbr_credit_bd;

truncate table dbr_acc_slip;
truncate table dbr_acc_slip_bd;

truncate table dbr_pos_closing;

truncate table dbt_log_access;
truncate table dbt_list_type1;

truncate table pro_post;

truncate table crp_wallet;
truncate table crp_wallet_token;

truncate table pro_post;
truncate table pro_post_bd;
truncate table pro_sorder_shop;

truncate table dbr_bal_reward;
truncate table dbr_bal_supplier;
truncate table dbr_bal_buyer;
truncate table dbr_bal_acc_title;
truncate table dbr_bal_credit;
truncate table dbr_credit;
truncate table dbr_credit_bd;
truncate table dbr_customer_tie;
truncate table dbr_customer_tie_bd;

truncate table pro_company_contact_bd;
truncate table pro_company_crcard_bd;
truncate table pro_company_destina_bd;
truncate table dbr_coupon;

truncate table zdb_eyetest;
truncate table zdb_sales;
truncate table zdb_sorder;

truncate table dbt_list_sum;
truncate table dbt_list_type1;
truncate table dbt_log_access;
truncate table dbt_upload_type1;
truncate table dbt_webcat_cart;

truncate table main_sso_app;
truncate table main_sso_app_bd;
truncate table main_sso_app_log;

truncate table pro_cart;

truncate table pro_item_review;
truncate table pro_item_review_bd;
truncate table pro_item_revpro;
truncate table pro_item_revsum;

truncate table bcs_block;
truncate table bcs_circulating;
truncate table bcs_contract;
truncate table bcs_dgn_holder;
truncate table bcs_nft;
truncate table bcs_token;
truncate table bcs_token_holder;
truncate table bcs_trans_inter;
truncate table bcs_tranxn;
truncate table bcs_txn_transfer;
truncate table bcs_uncle_block;
truncate table bcs_unconfirm;
UPDATE bcs_last_sync_no SET last_sync_no = 0 where id = 1;

truncate table bcm_contract;
truncate table bcs_contract_abi;
truncate table bcs_contract_sol;
truncate table bcs_token_add;
truncate table bcs_token_holder;

truncate table fed_crystal_guest;
truncate table fed_crystal_host;

[개발설정용 테이블 테이블]-기본데이터 초기화에서는 Truncate 불가

truncate table pro_item_revindex;

truncate table dbr_media;
truncate table dbr_media_bd;

truncate table pro_widget_taxo;
truncate table pro_widget_taxo_bd;
truncate table pro_item_taxo;
truncate table pro_item_taxo_bd;

truncate table pro_member_device;
truncate table pro_member_passwd;
truncate table pro_member_log;

[지우지 말아야 할 테이블]

dbr_deal_type
dbr_etc
dbr_user_menu
dbr_rpt_custom